How do I see what the character set that a MySQL database, table and column are in? Is there something like SHOW CHARACTER SET FOR mydatabase; and SHOW CHARACTER SET FOR mydatabase.mytable; and SHOW CHARACTER SET FOR mydatabase.mytable.mycolumn; ...
Hi Folks. I'm just having this trouble with Wordpress: I use to have a Blog with and older version of it and of MySQL, and when I export the SQL DB Creation Scripts, they exported with the latin1_swedish_ci Collation. Know I'm trying to rebuild the blog but it shows a lot of strange characters like: Imaginaré Creativitá When It mu...
I have a table with a column using utf8_unicode_ci character set. This table stores Japanese data and my problem is that using this character set, I'm not able to store the same word written in katakana and hiragana because it's considered to be the same word. For example わたし and ワタシ, which mean I, me. I know that I can change the char...
I am using Ubuntu 9.10 with XAMPP ( Lampp "MYSQL 5.1.45 PHPMYADMIN 3.3.1 PHP 5.3.2 ) What my problem is, is that I set up my testing env to debug my scripts locally and when I did so there arose a problem. This problem is that I used firefox's addon SQLinject ME to test for weakness' and upon doing so it caused mysql to change the defaul...
I am trying you insert some string which is not in English (other language). when i fetch back they are not correct. They comes like "?????". But at the same time when I enter the string through the SQL Server UI (SSMS) to enter the string, it works OK. What could be the solution please? ...
Hello, I am working on a simple search script that looks through two columns of a specific table. Essentially I'm looking for a match between either a company's number or their name. I'm using the LIKE statement in SQL because I am using InnoDB tables (which means no fulltext searches). The problem is that I am working in a bilingual e...
Perhaps I don't have enough of an understanding of this yet, so I'm looking for a little direction. All of our tables show a collation of latin1_swedish_ci. Here's what I see in the mysql variables: collation connection utf8_general_ci (Global value) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedis...
The problem A friend is developing a Swedish dictionary web application. One use will be for checking words in Scrabble games. The Swedish Scrabble rules (in Swedish) allow for example 'a' and 'á' to be treated as the same letter, but not 'u' and 'û' or 'y' and 'ü'. The Swedish collation rules (latin1_swedish_ci) think differently and t...