Roger,
>>>
>>> (please note, this is a bottom-post forum)
>>>
>>> On 3/13/2018 7:54 PM, Roger House wrote:
>>> >
>>> > On 03/13/2018 03:11 PM, Reindl Harald wrote:
>>> >>
>>> >>
>>> >> Am 13.
2:59 schrieb Roger House:
>>> In all respects except one, the treatment of Unicode works just
fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute
ects except one, the treatment of Unicode works just fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>
Hi Roger,
(please note, this is a bottom-post forum)
On 3/13/2018 7:54 PM, Roger House wrote:
>
> On 03/13/2018 03:11 PM, Reindl Harald wrote:
>>
>>
>> Am 13.03.2018 um 22:59 schrieb Roger House:
>>> In all respects except one, the treatment of Unicode works j
I am running Ubuntu MATE 16.04. I have the problem also on Windows 7
and on Mac OS Version 10.11.6. I do not think that the problem has to
do with the operating system nor the terminal. Everything about the
Unicode text works fine in all tools such as editors, the cat command,
etc. It is
Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the treatment of Unicode works just fine. I
can write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysql, the MySQL Command-Line Tool. When I
execute a SELECT statement to see
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use a
cmd" under Windows, see what others had to do for other
programs:
https://stackoverflow.com/questions/388490/unicode-characters-in-windows-command-line-how
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I use a Python program to write text containing Unicode characters to a
MySQL
database. As an example, two of the characters are
u'\u2640' a symbol for Venus or female
u'\u2642' a symbol for Mars or male
I use utf8mb4 for virtually all character sets involved wit
Thanks for that answer. It squares with my solution: have an additional
column that has the lower case values of the case sensitive unicode
setting.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 11/25/14 6:48 AM, "Rik" wrote:
>Not a uni
Not a unicode one that I know of, converting it to latin1 for the grouping
works for that particular use case, but I can't make any promises how it'd
work on your entire set which may hold any unicode character, a lot of
which cannot be converted to latin1:
mysql> SET NAMES utf8;
Que
Is there a unicode setting on mysql that is case insensitive but
diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for
such a setting would return two values: 'été', 'ete'. I couldn't find
it, but I may not have know
2011/1/20 :
> Hi,
I lack on knowledge about "Informatica" software. But if you are
really sure that the problem is not on source data and not on backend
configuration, then it is just in the middle. :-)
I will be more specific (at least, as far as I can be). In a MySQL, a
charset is negotiated o
Hi,
Currently we are trying to load Unicode data encoded in UTF-8 to mySQL but the
data is getting corrupted during load. Loading is done through Informatica (ETL
Tool) and data is properly extracted and interpreted by Informatica but still
it is failing to load it in the correct format. When
Hi,
I have a database with UTF8 characters. These are shown correctly by the
query browser.
I installed the odbc/connector 5.1 and tried to access the same table using
OpenOffice base and a Qt application I wrote myself.
In both clients the UTF8 character so not show up properly as if the dat
lt;:]]que[[:>:]]'
> Matches que, not queue, but doesn't match qué.
>
> attempt3
> SELECT * FROM t WHERE txt REGEXP
> '[[:<:]]q[uùúûüũūŭůűųǔǖǘǚǜ][eèéêëēĕėęě][[:>:]]'
> Matches que, queue, qué. (I have no idea why this matches queue, but
> the Regex beh
:<:]]que[[:>:]]'
> Matches que, not queue, but doesn't match qué.
>
> attempt3
> SELECT * FROM t WHERE txt REGEXP
> '[[:<:]]q[uùúûüũūŭůűųǔǖǘǚǜ][eèéêëēĕėęě][[:>:]]'
> Matches que, queue, qué. (I have no idea why this matches queue, but
> the Regex b
x27;[[:<:]]q[uùúûüũūŭůűųǔǖǘǚǜ][eèéêëēĕėęě][[:>:]]'
Matches que, queue, qué. (I have no idea why this matches queue, but
the Regex behavior is bizarre with unicode.)
Does anyone know why the final regex acts weird? It there a good solution?
Thanks in advance,
John Campbell
--
MySQL Gen
llation of
utf8_general_ci. - That collation is less than perfect, - utf8_unicode_ci is
more accurate, but slower. However, collation might not be an issue for you.
See http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html.
hth.
~mm
On Thu, Dec 4, 2008 at 1:01 PM, Ali, Saqib <[EMAIL PROT
>-Original Message-
>From: Ali, Saqib [mailto:[EMAIL PROTECTED]
>Sent: Thursday, December 04, 2008 1:02 PM
>To: mysql@lists.mysql.com
>Subject: Re: How to create a unicode capable table??
>
>Hello,
>
>Any thoughts on this? Thanks.
>
[JS] I'll be inte
Hello,
Any thoughts on this? Thanks.
On Tue, Nov 25, 2008 at 8:14 PM, Ali, Saqib <[EMAIL PROTECTED]> wrote:
> What Charset and Collation should I use while creating a mysql table
> such that it can take data from unicode SQL Server DB table?
>
> Thanks
> saqib
> http:
What Charset and Collation should I use while creating a mysql table
such that it can take data from unicode SQL Server DB table?
Thanks
saqib
http://doctrina.wordpress.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
ql604.latin1_general_ci.html
As you can see, all accented letters are considered as separate letters.
So when you do:
SELECT ... WHERE a='a'
you only get 'a' and 'A'. But you wan't get any other variants of the
letter 'a',
That doesn't support Un
what
you want basically, and I think there might possibly be a need for this.
That would effectively be what I originally wanted. Use Unicode for
sorting things, but do not use Unicode for comparing with the =
operator. LIKE may work with Unicode, as its name already implies a
level of fuzzyness. I
Yves!
OK. I agree I don't like this much myself, but we have to live with
the multi-lingual aspect of UNICODE. Or rather, we have to agree to be
either multi-lingual, and have the cons and pros of that (using
UNICODE), or ignore UNICODE and have binary collations etc. And
collation
yves
when creating a varchar field in table creation, use the binary.
that way, selection is exact. always.
david
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 1:44 PM
To: Anders Karlsson
Cc: MySQL
Subject: Re: Unicode sorting and binary
On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote:
> [a lot about why sorting unicode is complicated]
If you want to
accknowledge exact matching, and say any character, accented / unlauted
etc, is different from any other character, specifiy a binary comparison:
SELECT * FROM phonebook WH
se in any type of listing, phonebooks etc, as
the accent just wasn't there. The names Linden and Lindén are pronounced
differently, but sorted together as the accent wasn't there at all.
To you specific problem then, the issue is that as we can have just
about every character in the wor
Hello,
I've just read through the MySQL documentation about Unicode support,
collations and how it affects sorting and comparison of strings. And I
find it horrible, at least. I feel like I'm back in the MySQL 3.x days
where I used UTF-8 in my application and MySQL treated it b
t: Friday, September 28, 2007 1:55 PM
> > To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> > Subject: Storing Devnagari unicode data in MySQL
> >
> > Namaskar,
> >
> > I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with
> > Microsoft
> > Mar
> -Original Message-
> From: C K [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 28, 2007 1:55 PM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Storing Devnagari unicode data in MySQL
>
> Namaskar,
>
> I am using Windows Xp SP2 and Mysql 5.0
Namaskar,
I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with Microsoft
Marathi Indic IME 1 version 5.
I am storing data in both languages i.e. Marathi and English. So I changed
database character set to 'utf8 -- UTF-8 Unicode' and collation to
'utf8_unicode_ci'
lient), when I'm in a
SSH (Secure Shell) Session, in a SUSE Linux Enterprise Server 10,
configured to use Unicode (UTF-8 encoding).
The Portuguese accented characters appeared well, in the same SSH
session, for other shell (bash) commands and in Vim editing sessions
(using the same Portuguese keyb
Session, in a Linux Server
configured to use Unicode (UTF-8 encoding).
I'm using "dead keys" - http://en.wikipedia.org/wiki/Dead_key - to
enter the accented characters. That is, if I press the ã (tilde sign)
key on my keyboard and then press "a" (lowercase a) then I get &q
Hello everybody,
I want to store Myanmar unicode data in MySQL
database. Then, I want to make data manipulation with it. Firstly, i
tried to input Myanmar characters in MySQL's GUI tool. i chose Myanmar
keyboard and installed Myanmar font in tool. But, i couldn't ty
Hi,
Ok, thx for your help, it's a little bit faster, but also much too slow.
And what can I do that I can find such characters like 'ä' with a select
like:
SELECT * FROM myTable WHERE myField like '%a%'
in the unicode-field?
br
Charlie
> -Ursprünglich
Hi Charlie,
The performance problem may be due to using UTF-8 instead of unicode.
Try declaring your text column as:
my_text VARCHAR(...) UNICODE
I am guessing, but it may be that the search is slow because MySQL
has to convert UTF-8 to UNICODE before doing the comparison.
BTW, don
TECTED]
Sent: Monday, September 11, 2006 5:58 AM
To: mysql@lists.mysql.com
Subject: Unicode
Aloa,
ich muß in einer Webanwendung jetzt auch noch Daten von verschiedenen
Ost-Ländern wie zB Bulgarien, Polen, Tschechien usw. integrieren.
Das hätte ich mir eigentlich alles recht einfach vorgestellt, aber leid
Aloa,
ich muß in einer Webanwendung jetzt auch noch Daten von verschiedenen
Ost-Ländern wie zB Bulgarien, Polen, Tschechien usw. integrieren.
Das hätte ich mir eigentlich alles recht einfach vorgestellt, aber leider
ist meine DB nach einer Umstellung von latin1 auf utf8 sehr langsam und die
Suche
COMPILED_CHARSETS
lists in configure.in.
Reconfigure, recompile, and test.
Thanks
Visolve DB Team.
- Original Message -
From: "khaing su yee" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 01, 2006 9:28 AM
Subject: want to insert unicode myanmar characters into MySQL data
I use Toad for MySQL 2.0 and SQLyog 5.02.
I want to insert unicode myanmar characters.
I change uft8 charset and utf8_unicode_ci collation.
But I can't insert myanmar characters.
What is needed to do?
Please tell me.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysq
Hi all,
I have to create a database for Chinese, Japanese and Korean Language
support and a vb.net application for same.
Well I did couple of thing for this
1. created new database with Unicode CharacterSet
2. tables are also created with Unicode
w.
regards,
gu lei
- Original Message -
From: "Daniel Levy" <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTED]>
Sent: Thursday, March 23, 2006 3:26 PM
Subject: Re: Unicode (UTF-8) question
> Dear Gu Lei,
>
> Again, thank you very much for your r
rs data, but
> every once in a while I do need to, usually this is while reviewing
> logfiles.
>
> Here is an example. Selecting a text field from a table I get the string
> (truncated):
> "aHR0cC8xLjAgMjAwIG9rDQpzZXJ2ZXI6IDB3LzAuNmQNCmRhdGU6IHRc3"
>
get the string
(truncated):
"aHR0cC8xLjAgMjAwIG9rDQpzZXJ2ZXI6IDB3LzAuNmQNCmRhdGU6IHRc3"
My wild guess is that this is a unicode string. Is there any way for me to
work with this raw data and display the text in it's native character set?
Thanks,
Gary
--
MySQL
Mohsen wrote:
> But himself solved his problem.
> with : mysql_query("SET NAMES utf8");
> Even 4.0.x
Wrong.
I decided to prepare two different versions for my software:
- A MySQL 4.0-friendly version using Romanizing method (Hats off to you,
Ehsan)
- A MySQL 4.1-compatible
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 18:36:25:
> On 24/11/2005, Alec worte:
>
> > I think this is your problem: MySQL does not properly support
Unicode
> > until version 4.1. I am successfully using FullText with MySQL
> 4.1 to sort
>
On 24/11/2005, Alec worte:
> I think this is your problem: MySQL does not properly support Unicode
> until version 4.1. I am successfully using FullText with MySQL 4.1 to sort
> UTF-8 encoded Japanese text. I see no reason why it should not work for
> Arabic - if
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 17:48:29:
> Dear list,
>
> I'm considering programming a simple "Search Engine" for a website,
> to find Arabic/Persian data within a MySQL database.
> This database contains a huge amount
Dear list,
I'm considering programming a simple "Search Engine" for a website,
to find Arabic/Persian data within a MySQL database.
This database contains a huge amount of data, encoded with Unicode (UTF-8).
The big deal is to ** reduce the response time ** to end
At 20:15 -0700 11/2/05, Steve Johnson wrote:
The documentation notes that BLOBS must escape certain characters ( NULL, etc
.
What documentation are you referring to?
Also, NULL is not a character. Do you mean NUL (byte with value of 00)?
I suspect the escaping that you're referring to is esca
The documentation notes that BLOBS must escape certain characters ( NULL,
etc ). Since a blob is not of any character set, how do I know how to
prepare a blob for insert? ( which character set / character size to use to
test for characters that need to be escaped?
Thanks,
Steve
--
MySQL Ge
Hello.
If you want to setup such kind of database you could put
all necessary variables to your configuration file, then restart
the server and create a new database. For example:
[mysqld]
default_character_set=utf8
[client]
default_character_set=utf8
Check with
read:
>
http://dev.mysql.com/doc/mysql/en/charset.html
>
>
>
>
> "Roberto Jobet"
<[EMAIL PROTECTED]>
wrote:
> > Hi,
> >
> > I'm using MySQL
4.1.11
> >
> > I need to setup
a multilingual
database to support
> > a lot of forei
f foreign
> languages.
>
> Do I have to setup a
> UTF-=
> 8 unicode
> database ?
>
> Does anyone have a
> step-by-step guide
> on how t=
> o achieve
> this ?
>
> Thanks for any help
>
> Regards
>
> Roberto=0A=0A=0A=0A=
>
Hi,
I'm using MySQL
4.1.11
I need to setup a
multilingual
database to support
a lot of foreign
languages.
Do I have to setup a
UTF-8 unicode
database ?
Does anyone have a
step-by-step guide
on how to achieve
this ?
Thanks for any help
Regards
Ro
Patrice Serrand wrote:
mysql_query (mysql, "INSERT INTO db_unicode.unicode_tbl VALUES (6, _utf8
'atüpedâ' COLLATE utf8_general_ci)");
I'm no Unicode expert, but I've never seen that _utf8 bit before. What
is it? Or more accurately, what do you expect
e.
To get the same result I have to write :
mysql_query (mysql, "INSERT INTO db_unicode.unicode_tbl VALUES (6,
'atüpedâ')");
Everything works like if the C API only accepts ANSI strings.
Is it possible to directly insert an unicode string using the C API ?
Is it possi
Hello.
>But I've been told that the support for Unicode is not yet good in MySQL. Is
>it possible to find whether this is true?
I don't think so, as most bugs related to utf8 are reported about the fifth
version
while utf8 support in fourth seems very stable.
Ra
ion
Valsainte
Witham
The documentation at www.mysql.com indicates how things can be modified. But
I've been told that the support for Unicode is not yet good in MySQL. Is it
possible to find whether this is true?
I would also need that the user can type : Stipa without the accent, and fin
I know this issue has been brought up many times and I have tried to
search and read as much as possible but still have not been able to
resolve my issue. I have a mysql database (not the latest but it
supports unicode). I am keeping some columns in utf8 format and only
save data that is in utf8
Hi all!
I've a problem with insert unicode characters on my database. I use
Mysql 4.1.10 on Win and Linux-Debian and I share the same database. My
server, client and database are on utf8 character, but my keyboard is on
Spanish.
I need introduce IPA characters on my table of a database wh
Hi all!
I've a problem with insert unicode characters on my database. I use
Mysql 4.1.10 on Win and Linux-Debian and I share the same database. My
server, client and database are on utf8 character, but my keyboard is on
Spanish.
I need introduce IPA characters on my table of a database whit o
one has to encode "extend string or any unicode" to utf-8 first and then insert
it to MySQL database 4.1
Most likely you did not encode them to utf-8.
zhi peng
"Steve Quezadas" <[EMAIL PROTECTED]> wrote:
>Hey guys,
>
>I just upgraded to mysql 4.1 and I
Hello.
Use MySQL Query Browser instead of MySQL CC. What output does the
following statement produce:
show variables like '%char%';
"Steve Quezadas" <[EMAIL PROTECTED]> wrote:
> Hey guys,
>
> I just upgraded to mysql 4.1 and I'm tryi
Hey guys,
I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work in
my database. I put "default-character-set=utf8" in my my.cnf file and
restarted the database. Then I created a brand new database new table, new
field. I try hooking into the newly created data
"latin1", some are "utf8"). Is this producing my Unicode crap output? In
MySQL Query Browser, all values appear UTF-8 encoded. It's not the
correct characters like Ã, Ã or Ã, but their UTF-8 represantation. I
know that and that's OK. But PHP shows some of the charact
Hello.
You may use _utf8 0xXX form of input, where is 0x - hexademical
representation of your japanese string (each unicode character has it's own
hexademical value). For an example see:
http://dev.mysql.com/doc/mysql/en/Charset-literal.html
>hi
>i want to do a i
hi
i want to do a insert query which contains
utf 8 (japanese characters) characters in the database but surprisingly when i
done this it stores ??? and also when i retrieves it fails to give actual
picture
iam using mysql 4.1.b alpha using mysqlcc as
my editor and dos promt
looking for
rovements after 5.8.1, especially since
Unicode support is used a lot less than ascii historically. Also, make
sure you have DBI 1.46 and DBD::mysql the newest. -- Darren Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: "angie ahl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, December 01, 2004 9:26 AM
Subject: Unicode (utf8) and MySQL (with Perl)
> Hi List.
>
> Please excuse the cross posting but I
unitest where id = "smiley;"
then use perl to decode the returned value like so:
decode("utf8", $aword)
This doesn't work for me properly. However when I insert them like this:
INSERT INTO unitest (id, aword) VALUES ( "$smiley", '\x{263a}' )
Hello.
Look at output produced by:
show variables like '%char%';
and
show create table 'your_unicode_table';
If you use Unicode, the most obvious that all charsets should be the same.
But if you see something else, probably you should correct that.
More you
Hi, I am using MySQL 4.1.1 and all databases, columns are set to UTF-8 encoding
I have try both MySQL cc and Query browser and try to enter some
Chinese character, but when I print out the HEX value of the
character. It isn't in Unicode that I expected, but i can't see those
Chinese
r sets support. I have data
> getting inserted that has various unicode characters embedded such as
> the Registered Trademark symbol, and various foreign language characters.
>
> my tables are innodb and I set them to use utf-8, macroman and macce
> character sets, and the uni
I'm running mysql 4.1.7 on linux. I recently made the upgrade from 4.0.1
to 4.1.7 to get the additional character sets support. I have data
getting inserted that has various unicode characters embedded such as
the Registered Trademark symbol, and various foreign language characters.
my t
Hi all,
I have been struggling to get MySql to accept Unicode characters for a while
now with no success. I am attaching a small example program as well as a
mySql dump in hopes that someone can help.
The expected behavior is that the program should insert a curly quote and a
'one qu
"Stefan Klopp" <[EMAIL PROTECTED]> wrote:
> We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
> that all of our Unicode characters are now being displayed as question marks
> (?). Anyway this only happens when viewing over the web as when we view
I am not sure whether I was actually managing the Unicode characters or
whether they were just being stored and retrieved. Regardless I am not on
version 4.1 either, only 4.0.
Stefan
- Original Message -
From: "Jean-Marc PULVAR" <[EMAIL PROTECTED]>
To: "Stefan Klo
(B
(B- Original Message -
(BFrom: <[EMAIL PROTECTED]>
(BTo: "Stefan Klopp" <[EMAIL PROTECTED]>
(BCc: <[EMAIL PROTECTED]>
(BSent: Wednesday, July 21, 2004 5:36 PM
(BSubject: Re: after upgrade unicode characters changed to question marks
(B
(B
(B> Hi
You were managing unicode characters with mysql 3.23?
It was just storing and retrieving the data then?
Because mysql can really manage unicode in 4.1 version, isn't it?
Stefan Klopp wrote:
Hello All,
We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
that all of our Un
Unicode compilation (
Project Properties > General > Use Unicode Character Set ). My test app has a
CWinThread-derived class named CDBThread, with a CDatabase member.
CDBThread::InitInstance() calls OpenEx() for the CDatabase member. So far so good.
For the app's InitInstance, all I
Hello All,
We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
that all of our Unicode characters are now being displayed as question marks
(?). Anyway this only happens when viewing over the web as when we view via
the shell mysql we can see the characters fine. In addition
> Could someone who has experience with handling the Unicode character
> set in a MySQL database please write to me? In particular, I am
> trying
> to discover how in an ASCII-limited environment one can specify
> non-ASCII characters; I do know their Unicode encodings, jus
Could someone who has experience with handling the Unicode character
set in a MySQL database please write to me? In particular, I am trying
to discover how in an ASCII-limited environment one can specify
non-ASCII characters; I do know their Unicode encodings, just not how
to write an INSERT
At 13:56 +0200 7/5/04, Pascal Francq wrote:
Hi,
I try to create with MySQL 4.0.18 a database with unicode as default character
set. So I use the command:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;
I receive the message when i try this command:
ERROR 1064: You have an error in your SQL
Hi,
I try to create with MySQL 4.0.18 a database with unicode as default character
set. So I use the command:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;
I receive the message when i try this command:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds
It seems like all of the questions in the past regarding Unicode have
been of the form: "Does MySQL support it?" I can see that it does, but
I was wondering if anyone could point me to an example of an INSERT or
an UPDATE on a string that is encoded using Unicode so I can see
exact
Hi,
I am really pleased with the new unicode features of MySQL4.1.2 alpha release. I am
just a little surprised that there is still only one API call which returns the
character set??? (And it returns the collating encoding instead of the real character
set?)
I was wondering if there is a way
a software.
Cheers!
-James Huang
//
// File: connect.judi
//
connect to
'jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=utf-8',
'myuser', 'myuser';
//
// File: mysqltest.judo
//
!include 'connect.judi'
asUnicode =
Are you characters being escaped before being stored?
\u?
-Original Message-
From: Silvio Lopes de Oliveira
To: Victor Pendleton; James Huang ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 6/2/04 6:24 PM
Subject: RE: Unicode characters become question marks
You know, now I'm sure
[EMAIL PROTECTED]
Subject: Re: Unicode characters become question marks
Date: Wed, 02 Jun 2004 13:04:38 -0500
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Victor,
>
> I'm positive the database is storing ?'s. You may test with these steps:
>
> 1) ins
I tried SELECT HEX(your_column) FROM your_table and indeed, only '?' is being stored
(3F hex, 63 decimal). Thanks for the hint regarding Unicode support in MyODBC, I'll
try to read more on it tomorrow. I've had enough frustrations for the day... :)
Thanks.
S Lopes
-
re to do is execute this query from the client:
SET CHARACTER SET utf8;
The best way to see what is actually being stored is to select the hex
value of the column:
SELECT HEX(your_column) FROM your_table;
To see hex values as unicode codepoints convert the utf8 to ucs2:
SELECT HEX(CONVERT(your_c
TECTED]
Sent: Wednesday, June 02, 2004 10:09 AM
To: Silvio Lopes de Oliveira; Victor Pendleton; 'James Huang ';
'[EMAIL PROTECTED] '
Subject: RE: Unicode characters become question marks
If you can type the character into the keyboard try this.
SELECT IF(col1=, 1,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Thanks, Mark. This instills great confidence in me.
>
> I used this URL:
> "jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=utf8"
> (should I use "utf-8" perhaps?) Would this work, too?
James,
Either should work, i
PROTECTED]
Subject: Re: Unicode characters become question marks
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Victor,
>
> I'm positive the database is storing ?'s. You may test with these steps:
>
> 1) insert "\u7247\u4EEE\u540D" into
? That doesn't look like a standard JDBC method.
-James
From: Mark Matthews <[EMAIL PROTECTED]>
To: James Huang <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Unicode characters become question marks
Date: Wed, 02 Jun 2004 13:04:38 -050
-4.1.x,
what I put in is what I get back out, so my guess is something between
the database and your display is munging the characters...Is whatever
you're using for output set to the correct encoding?:
As Java Unicode (int)chars:
7247
4eee
540d
Retrieved from database as (int)chars:
7247
4eee
5
ding from the db.
S Lopes
-Original Message-
From: James Huang [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 10:18 AM
To: [EMAIL PROTECTED]; Silvio Lopes de Oliveira;
[EMAIL PROTECTED]
Subject: RE: Unicode characters become question marks
Victor,
I'm positive the dat
1 - 100 of 248 matches
Mail list logo