Am 05.02.2007 um 18:11 schrieb Chris White:
SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small
eta]'
that *should* ( see disclaimer ;) ) give you what you need
Yes, it does.
I should have also asked for SELECT DISTINCT fieldname ... in the
first place, but looking at your an
Sven Fuchs wrote:
These characters are stored/retrieved correctly. But they are wrongly
regarded the same character by statements like SELECT * FROM tablename
WHERE fieldname LIKE '[greek small eta]'
The database's character-set is set to "UTF-8 Unicode (utf8)" and the
table's and varchar fie
On Tue, 2004-11-09 at 23:17, [EMAIL PROTECTED] wrote:
> What does this all entail?
You can use Arabic/Chinese etc characters
>Can we use Under_Scores in table names.
Yes. This is not effected by UTF8 anyway.
--
Edward A. Macnaghten
http://www.edlsystems.com
--
MySQL General Mailing Li
hi mark,
What happens if you explicitly specify the table character set to be
'utf-8'? (i.e. you're relying on the database default character set to
take care of that for you right now)...
'CREATE TABLE foo CHARACTER SET utf8'
the same.
All I can say is that with the testcase I posted, it is shown
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert kuzelj wrote:
> hi mark,
>
>> If you specify UTF-8 as the characterEncoding connection property, then
>> that is the transform that is used from client -> server. The transform
>> that is used from server -> client is whatever character set the
hi mark,
If you specify UTF-8 as the characterEncoding connection property, then
that is the transform that is used from client -> server. The transform
that is used from server -> client is whatever character set the column
in the table is set to when you created the table (or conversely if you
us
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert kuzelj wrote:
> hallo mark,
>
>> Hopefully the following JUnit testcase helps show that your problem
>> doesn't exist at the JDBC level. It creates a UTF-8 connection to
>> MySQL-4.1.2, stores UTF-8 encoded strings directly and by prepared
>> s
hallo mark,
Hopefully the following JUnit testcase helps show that your problem
doesn't exist at the JDBC level. It creates a UTF-8 connection to
MySQL-4.1.2, stores UTF-8 encoded strings directly and by prepared
statements, retrieves them, compares to original as strings, and
byte-for-byte using t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert kuzelj wrote:
> hi mark,
>
> > However, once you start displaying things on the console, all bets are
> > off...because your console needs to understand UTF-8 as well, so using
> > the 'eyeball' method of testing won't work too well here.
>
hi mark,
> However, once you start displaying things on the console, all bets are
> off...because your console needs to understand UTF-8 as well, so using
> the 'eyeball' method of testing won't work too well here.
in principle i agree with you. but only having java tests is simply
not enough. i ha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert kuzelj wrote:
> [code]
> 18String family = new String(rs.getBytes("FAMILY_NAME"));
> 19String given = new String(rs.getBytes("GIVEN_NAME"));
> [/code]
>
> [result]
> [java] .Käßsel - Böb
> [java] Ægÿl - Àlbért
>
seems like my problem is not necesseraly tied to mysql.
at least i can reproduce all of this also with postgres.
instead of writing to the database i tried to read from
it (after inserting data via the following simple script on the
commandline)
[code]
[EMAIL PROTECTED]:> more example_insert.sql
in
hi Yiannis,
Try changing Eclipse's setting to saving the files as UTF-8 and also force the
JVM to the UTF-8 file encoding.
eclipse is already set to only write UTF-8. but how should i force
the jvm to work with that encoding?
ciao robertj
smime.p7s
Description: S/MIME Cryptographic Signature
Try changing Eclipse's setting to saving the files as UTF-8 and also force the
JVM to the UTF-8 file encoding.
-Original Message-
From: robert kuzelj [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 15:01
To: [EMAIL PROTECTED]
Subject: UTF-8 settings and woes
hi,
i am trying to write utf-8 d
Hi Beau,
basically, you can use anything from MySQL 3.x, as you like it. I'm on an
Internet Newsboard System for a while and switched that to UTF-8 for all
data handling, display and storage. (Even sending out UTF-8 e-mails and
Jabber messages...) You just have to give MySQL the UTF-8 encoded stri
version 4.1 and up are the versions to be unicode enabled.
Ligaya Turmelle
""Beau Hartshorne"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
I am about to start using UTF-8 for my internal data storage and display
for a CMS that I'm building. Are there any issues that I should
On Tuesday, December 16, 2003 10:29 AM CET, Adam Hardy wrote:
> On 12/16/2003 01:35 AM Ligaya Turmelle wrote:
>> Can anyone tell me what the current support for the UTF8 character
>> set is? How strong is it? Do I have to do anything special to save
>> the characters? I will be getting the charact
On 12/16/2003 01:35 AM Ligaya Turmelle wrote:
Can anyone tell me what the current support for the UTF8 character set is?
How strong is it? Do I have to do anything special to save the characters?
I will be getting the characters from a webpage form and inserting the
characters with PHP.
It depends
I've been storing data in UTF8 Unicode (Vietnamese) format in mySQL
database. I didn't see any problem of for doing any SELECT statement at
all.
Son Nguyen
--- "John D. Stein" <[EMAIL PROTECTED]> wrote:
> All,
>
> I can't seem to find anything about character code sets supported
Sven Bentlage asked
> Is there a way to get UTF-8 national characters sets working when you
> only have user access to a database (it's my ISP's)?
Whether you use the my.cnf/my.ini configuration file or the startup
parameter, it's a startup option. You have to have access to one or the
other.
Is there a way to get UTF-8 national characters sets working when you
only have user access to a database (it's my ISP's)?
(I know this is going to upset some people, but I do not have any time
left and RTFM won't help me right now..)
Can anyone of you send me a list/link to a list (or even be
* John D. Stein
> I can't seem to find anything about character code sets supported by
> MySQL. The only thing I found was a note about adding support
> for sorting
> on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html.
>
> What character sets does MySQL support? Is Unicode the de
Hi
Yes I do. There is no problem with this, except sorting etc.
Bu search is ok.
Regards
Daniel Las
> -Original Message-
> From: Dana Sharvit [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 13, 2001 6:35 PM
> To: '[EMAIL PROTECTED]'
> Subject: UTF-8
>
>
> If I understand correctl
UTF-8 is just another encoding scheme.
You can store UTF-8 just fine in MySQL (using BLOB, or perhaps even
CHAR), however you cannot do much more with it beyond storing.
Comparisons aren't likely to work, character-length calculations will
not work, etc. So if all you wanna do is store and retri
24 matches
Mail list logo