Solved

Character set has been locked to Latin1  Latin1_swedish_ci ?

Posted on 2007-12-04
3
865 Views
Last Modified: 2008-02-01
Hello all,

I have created several db with character set of utf8 for multilanguage
support,but from yesterday that i creat a new db ,i set character set
in Mysql Administrator to utf8 and utf8_general_ci but when i want
type persian i receive error 1366 ,when i see table options in Mysql

Administrator it is ok and is on utf8, but i try change the "NOT NULL"
and that in the box of Execute there is this message:

ALTER TABLE `testi`.`tbtest` MODIFY COLUMN `title` VARCHAR(45) CHARACTER SET

latin1 COLLATE latin1_swedish_ci;

so it seems that character set is locked to above (SWedish),is there any
solution?
Thanks
0
Comment
Question by:MOSTAGHASSI
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
michofreiha earned 125 total points
ID: 20402380

Well query browser has issues when concatenating queries together with static strings because of weird bug I am still working with the devs on, the workaround is to look at your static portions of the query and run a convert on them to make them UTF8 explicitly.

Please check the following:
http://dev.mysql.com/doc/refman/5.0/en/charset-server.html
http://dev.mysql.com/doc/refman/5.0/en/charset.html
0
 

Author Comment

by:MOSTAGHASSI
ID: 20402553
Thanks for your comment.
I read the articles and for creating new db i used comand line as:
CREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;
and it is good,now can you guide that how can apply this to an existance db?


0
 
LVL 9

Expert Comment

by:michofreiha
ID: 20402718
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question