Jump to content


Photo

MySql language character problem after import


  • Please log in to reply
5 replies to this topic

#1 Ozz

Ozz
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 22 November 2003 - 12:27 PM

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.
[a href="http://www.limk.com/english/" target="_blank"]Limk.com[/a]

#2 radalin

radalin
  • Members
  • PipPipPip
  • Advanced Member
  • 179 posts

Posted 23 May 2006 - 04:14 PM

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.
Roy Simkes
Yet Another Parkyeri Developer

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 May 2006 - 08:23 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 radalin

radalin
  • Members
  • PipPipPip
  • Advanced Member
  • 179 posts

Posted 25 May 2006 - 10:05 PM

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
Roy Simkes
Yet Another Parkyeri Developer

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 May 2006 - 05:20 PM

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?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#6 radalin

radalin
  • Members
  • PipPipPip
  • Advanced Member
  • 179 posts

Posted 26 May 2006 - 09:38 PM

Thanks for your time anyway.
Roy Simkes
Yet Another Parkyeri Developer




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users