Page 1 of 1
VARCHAR issue
Posted: Wed Sep 27, 2006 1:59 pm
by speedy33417
I'm doing a photo album that has Hungarian description for some pictures. Hungarian letters can be like this: Éíáú...
For some reason when a non-English letter should be displayed I get a "?" instead. How should I deal with it?
Thanks.
Posted: Thu Sep 28, 2006 10:31 am
by pickle
I've never had to deal with non-English character sets, but I believe you can set the character encoding for a field.
Posted: Thu Sep 28, 2006 9:27 pm
by shneoh
I am dealling with bytes charactors too (Chinese). Maybe my experience can help a bit:
1. Check your default charactor encoding of your output page. A simple find out is directly go to View-->Charactor Encoding and select the one you think mostly suits.
2. If you have used a wrong charactor encoding of your input page, problem will appears on your output page eventhough you have selected a correct encode on your output page.
I am a bit confused by the MySQL's encoding machanism, so I just tried my best to use the default on it and work hard on the script page.
Posted: Fri Sep 29, 2006 6:17 am
by speedy33417
Thanks shneoh. That's what I was experiencing as well. I didn't pay attention to selecting the encoding when creating my tables. Now that the fields are populated even if I switch to the right encoding it won't change anything when echoing my descriptions. However if I recreate that column using the right encoding it works fine.
Kind of strange...