Re: MySQL Data Type question
That looks like unicode, so you need to use a char based datatype that supports unicode.
I don't know what MySQL calls them, but for SQL Server it is NChar/NVarChar/etc. There may be "wide" in the name/description.
In terms of putting it into the database, make sure you use parameters - as the encrypted text is likely to (at some point) include escape characters that will cause errors if placed directly into SQL statements.
Re: MySQL Data Type question
The column needs to be declared as 'text'.
Re: MySQL Data Type question
I have tried type "Text", "LongText", "blob", and all the other usual suspects. The data types associated with “string” will store the text as “????????”. Type Blob places a big red “X” in the field, but will not store/retrieve the correct value.
The only data type that begins with “N” in numeric and it also stores/retrieves “????????”.
Re: MySQL Data Type question
I'd recommend reading the documentation, particularly 9.1.9:
http://dev.mysql.com/doc/refman/5.1/...alization.html
Re: MySQL Data Type question
don't confuse the data with the font being used to display the data....
-tg
Re: MySQL Data Type question
I am there now trying to figure out which utf8 unicode language to use. This does look like the right area though. thanks
Re: MySQL Data Type question
WEll, I can not find an MySql data type that will hold the unicode string. In my reading I have found that there are others with the same problem and most of the solutions revolve around using the convert to a base64 string. I will play around with this a bit more, but I sure could use advice if anyone has direct experience with this. Anyway- thanks for your help. :sick: