Re: Characters not getting stored
Posted by: Rick James
Date: April 04, 2013 07:48PM

I think the clue is here:

> I'm entering the letters from a german keyboard under Windows 7

Let's approach it in two ways.

Approach 1: What tool are typing the letters into? cmd? Notepad? WordPad? Word? Browser UI? Other? (My goal here is to blame that tool.)

Approach 2: Try this:
1. go to cmd
2. run the mysql commandline tool
3. Run this select:
SELECT 'ß', HEX('ß');
If the output's first column is not the sharp-s, then your input and output are inconsistent.
If the second column is 'DF', you are using latin1 or cp850 input. That means you should be using SET NAMES latin1;, which sets three of the CHARACTER* variables to latin1.
If you get C39F, the that is correct utf8, and the mystery continues.

> for 'Forlì': 'Forl', 466F726C, 4, 4.
> for Förlìßen: 'F', 46, 1, 1.
Those merely point out that the data was truncated at the bad (probably latin1) character during input.



Edited 1 time(s). Last edit at 04/04/2013 07:49PM by Rick James.

Options: ReplyQuote


Subject
Views
Written By
Posted
4988
April 02, 2013 01:19PM
Re: Characters not getting stored
1840
April 04, 2013 07:48PM
2081
April 05, 2013 01:00AM
1942
April 05, 2013 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.