2007/4/2, Luca Accomazzi <[EMAIL PROTECTED]>:
I am having troubles using BBEdit together with MySQL and I was
hoping the communal mind of the list might help me. I have a MySQL
database containing the localization of the strings for my webapp.
The database is Unicode:
CREATE DATABASE `sarat` /*!40100 DEFAULT CHARACTER SET utf8 */;
The table is Unicode:
CREATE TABLE `unilocal` (
`stringa` text character set utf8
[...etcetera...]
My Terminal is set to Unicode. If, for example, I "SELECT stringa
FROM unilocal", for a Russian text, I do see the correct Cyrillic
text in my Terminal window. So far, so good.
Now, if I SELECT the same string INTO OUTFILE 'whatever.txt' and I
open whatever.txt, then I see garbled text. At the bottom, I see that
BBEdit correctly opened the file as unicode utf-8 no bom. And I'm
stumped.
What I'm really trying to do is importing some new translations into
the database. Again, in BBEdit I see garbage. If I try to go ahead
and import blindly, I get MOSTLY garbage (lowercase Cyrillic letters
seem OK, uppercase and punctuation is garbled).
Banging my head into the wall repeatedly doesn't seem to help, too.
Oh: latest BBEdit and MySQL 5.0.24a-standard, just in case this makes
any difference.
L.A.
I think this is a MySQL issue, having to do with the character set of
the result. Try the following: before you do the 'SELECT INTO OUTFILE'
thing, execute the following query:
SET NAMES utf8;
See also: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
HTH,
JP
--
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
