The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
2k views

MySQL transfer ISO-8859-1 to UTF-8

How to transfer data from Database with latin1 character set, to database UTF-8. And on transferring convert data from latin1 to UTF-8 e.g., û->ū, ë->ė, þ->ž, á->į and etc.
4
votes
2answers
780 views

MySQL - Changing DB CHARACTER SET

I have a 30GB MySql DB, made of innoDB tables. currently the tables character set is: "utf8_unicode_ci" and I want to change it to "utf8_general_ci", what the best way to do it? currently i'm going ...
0
votes
4answers
471 views

MySQL - speed up execution of ALTER TABLE

I have a MySQL DB with innoDB tables. the DB size is about 30GB. I am using ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; to change all the tables characters set and it ...
5
votes
3answers
876 views

Querying special characters

I work with language with special characters (example: e -> é). I have a query with a LIKE but when I search a word with special char and my query doesn't have the special char, I don't get the ...
4
votes
2answers
17k views

Determine Oracle session client character set?

I know how the database characterset (NLS_CHARACTERSET in select * from v$nls_parameters;) and the client character set (the client environment setting NLS_LANG) interact. What I can't find out ...
3
votes
1answer
2k views

What does WE8DEC mean?

It is one of the commonly used character sets. What does it stand for? Is it an acronym for something?