No Unicode when paste values from other Grid (?)

TAKIS · General User Joined: 18 Jul 2012 Posts: 9

generally, on simple copy&paste from notepad working there is no problem.

but when I tried to copy row values from grid (.NET application) failed.

watch the video

Robert Tucker · Posted: Wed Jul 25, 2012 9:16 am Post subject:

Maybe the characters aren't Unicode; NotePad detects this but OpenOffice doesn't. Have you tried saving from NotePad checking the encoding is Unicode and then reopening the file? I notice you are using a database – the last time I used MySQL it did not use Unicode as the default. Have you checked the encoding used by the database?
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

TAKIS · General User Joined: 18 Jul 2012 Posts: 9

yes the grid is a resultset from MySQL.

Is nothing to do.

as you saw at movie, there is a /td> on cell something wrong at OOcalc.

Robert Tucker · Posted: Thu Jul 26, 2012 2:01 am Post subject:

Changing the default encoding to UTF-8 is probably something that greatly diminishes my inclination to play around with my dictionaries in MySQL. It's not something I remember how to do. These links may be useful, if you have not already found them:

http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnf

Again, I can't remember if there is some way from phpMyAdmin; if there was it probably required more than the odd couple of mouse clicks.

Of course, if you are dealing with an already populated database the problem is many fold worse, see:

http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html/

Using NotePad on each copy/paste to change the encoding as I described above I believe should work; I'm not sure why OpenOffice does not pop a dialogue up when you try to paste.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

TAKIS · General User Joined: 18 Jul 2012 Posts: 9

there is nothing to do with MySQL!

also when I connect to SQLServer is the same result!

Robert Tucker · Posted: Thu Jul 26, 2012 8:20 am Post subject: Re: re

I'm not sure I will be able to solve the problem you are having but find these two statements rather contradictory:

TAKIS · General User Joined: 18 Jul 2012 Posts: 9

Robert Tucker · Posted: Thu Jul 26, 2012 11:13 pm Post subject:

Well in my opinion it's almost certain that you have an encoding problem; the database using ISO-8859-7 and OpenOffice UTF-8 being the most likely from the given information.

I suspect the /td> comes from an incomplete copy; somehow you are copying the last HTML tag but not the first so OpenOffice thinks the /td> is text which is in Latin ascii/ansi characters, of course.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)