Page 2 of 2

Posted: Wed Jul 27, 2005 8:03 am
by pilau
That's quite bad, because I'm starting to work on a Hebrew forum right now, and if users will like to have nicknames in Hebrew, I bet it won't work, right?

Posted: Wed Jul 27, 2005 8:39 am
by onion2k
A database column set as latin1_swedish_ci won't be able to store Hebrew names, no. You have 3 options available to you:

1. Change the charset and collation of the column to a Hebrew setting.

2. Change the charset and collation of the column to a UTF-8 international setting.

3. Escape the data into something that can be stored in a latin charset, and unescape it again when you get it back out. Something like base64 encoding for example.