Ozz Posted November 22, 2003 Share Posted November 22, 2003 I have changed my server and first I export my sql file from old server. After importing this database to the new server I saw Turkish characters are turned like ı characters. There is no problem in the sql file before import. But after importing only TR characters are changing. And another strange thing that happens only some tables not all. I tried to figure out table preferences but nothing seem so important. I tried so many ways to get those characters normally but no result. Please help me to find out the solution. Quote Link to comment https://forums.phpfreaks.com/topic/1411-mysql-language-character-problem-after-import/ Share on other sites More sharing options...
radalin Posted May 23, 2006 Share Posted May 23, 2006 check for your collation in mysql tables. It might be the problem. Use latin5_turkish. I have such a problem too but it doesnt seem to be solved with collation options. I can write them correct on the db tables but while fetching I loose the characters. It might be because of encoding I have tried all the turkish encodings but it seems to fail again. Any idea? Did not want to open a new topic. Quote Link to comment https://forums.phpfreaks.com/topic/1411-mysql-language-character-problem-after-import/#findComment-38287 Share on other sites More sharing options...
fenway Posted May 23, 2006 Share Posted May 23, 2006 Collations are tricky, especially across different versions... it's easy to lose data this way. Please specify all pertinent information regarding the old and new servers, etc. I'll see what I can come up with. Quote Link to comment https://forums.phpfreaks.com/topic/1411-mysql-language-character-problem-after-import/#findComment-38375 Share on other sites More sharing options...
radalin Posted May 25, 2006 Share Posted May 25, 2006 I'm using wampserver with php5 and mysql5 support. Got an idea why can't i show turkish characters on the browser. Seems that everything fine in the db (at least i see them with phpmyadmin) but while the fetch operation, i can't get turkish characters. I tired differend character encodings but all seems to fail. Got an idea? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/1411-mysql-language-character-problem-after-import/#findComment-39032 Share on other sites More sharing options...
fenway Posted May 26, 2006 Share Posted May 26, 2006 Unfortunately, my expertise only includes MySQL -- if PHP is having trouble with these non-ASCII characters, I don't know how to help you. Maybe someone else has some insight? Quote Link to comment https://forums.phpfreaks.com/topic/1411-mysql-language-character-problem-after-import/#findComment-39228 Share on other sites More sharing options...
radalin Posted May 26, 2006 Share Posted May 26, 2006 Thanks for your time anyway. Quote Link to comment https://forums.phpfreaks.com/topic/1411-mysql-language-character-problem-after-import/#findComment-39297 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.