Hi, I am trying to get password from Java Password Field and store it in a table in MySQL database. This password is a char[] and I do not know how to store char[] as a column type in MySQL. How do we store arrays in database?
That's what I did. Convert the char[] to a string with new String(char[]) and then store it as a varchar in database. Thanks David. But can we store it as an array (as object?). MySQL documentation shows the matching column type for byte[] but not for other arrays.
I looked through the index for the MySQL 5.0 handbook, and it doesn't say anything about arrays, so I would presume you can't store arrays as such. Maybe as a blob? Don't know.