Current location: Hot Scripts Forums » Programming Languages » PHP » Problems with MySQL's Unicode handling


Problems with MySQL's Unicode handling

Reply
  #1 (permalink)  
Old 08-04-05, 01:16 PM
BonD's Avatar
BonD BonD is offline
New Member
 
Join Date: Aug 2005
Location: Kecskemét, Hungary
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Problems with MySQL's Unicode handling

Hello guys,

I'm a first-time poster and to make the problem more complex I'm from Hungary, so I'm not a native English speaker. The real problem is with my database server, that I recently installed on my computer for testing purposes.

My configuration is quite simple, a 2,4 Ghz P4 machine with a MS Windows XP SP2 installed on it and an Apache 2.054 webserver with PHP 4.4.0. The problem is when I try to run a really simple, database driven script I receive some funny characters instead of the characters of the Hungarian language. I use phpMyAdmin to manage my databases, so I've looked at my database and see all the characters as normal. However viewing in any other scripts, the special characters from my database becoming crappy... To show this, I've uploaded a screenshot that you can see here.

I don't know what to do with this. I've already asked this question in so many Hungarian forums but the guys there couldn't help me. I hope that you can help me out! Thanks in advance!
Reply With Quote
  #2 (permalink)  
Old 08-05-05, 07:59 AM
dennispopel dennispopel is offline
Coding Addict
 
Join Date: Mar 2005
Posts: 263
Thanks: 0
Thanked 0 Times in 0 Posts
Hello,

make sure you:
1. Specify the charset and collation of MySQL db/table/column
2. Issue the set names SQL query to set it to that charset
3. Exchange data with the client in that encoding
4. Your scripts are saved in that encoding
__________________
onPHP5.com - PHP5: Articles, News, Tutorials, Interviews, Software and more
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
2 spacing/alignment problems Arowana HTML/XHTML/XML 0 01-07-04 11:58 AM


All times are GMT -5. The time now is 07:00 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.