Storing UTF-8: does BLOB really work?

[Francesco Moi]

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

[Pack Fan]

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

Try NVARCHAR.

[Pack Fan]

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

Try NVARCHAR.

[Francesco Moi]

Thank you very much for your answer.

Is NVARCHAR supported? I tried with:
mysql> ALTER TABLE `my_table` CHANGE `my_field` `my_field` NVARCHAR(
100 ) NOT NULL
and I get this error message:
ERROR 1064: You have an error in your SQL syntax near 'NVARCHAR( 100
) NOT NULL ' at line 1

Thanks.

"Pack Fan" <pa**@fan.com> wrote in message news:<vs************@corp.supernews.com>...

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

Try NVARCHAR.

[Francesco Moi]

Thank you very much for your answer.

Is NVARCHAR supported? I tried with:
mysql> ALTER TABLE `my_table` CHANGE `my_field` `my_field` NVARCHAR(
100 ) NOT NULL
and I get this error message:
ERROR 1064: You have an error in your SQL syntax near 'NVARCHAR( 100
) NOT NULL ' at line 1

Thanks.

"Pack Fan" <pa**@fan.com> wrote in message news:<vs************@corp.supernews.com>...

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

Try NVARCHAR.

[Pack Fan]

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Thank you very much for your answer.

Is NVARCHAR supported? I tried with:
mysql> ALTER TABLE `my_table` CHANGE `my_field` `my_field` NVARCHAR(
100 ) NOT NULL
and I get this error message:
ERROR 1064: You have an error in your SQL syntax near 'NVARCHAR( 100
) NOT NULL ' at line 1

Thanks.

"Pack Fan" <pa**@fan.com> wrote in message

news:<vs************@corp.supernews.com>...

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

Try NVARCHAR.

My mistake. I was thinking MSSQL. Sorry.

This might help, though: http://www.mysql.com/doc/en/Charset-Unicode.html

[Pack Fan]

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Thank you very much for your answer.

Is NVARCHAR supported? I tried with:
mysql> ALTER TABLE `my_table` CHANGE `my_field` `my_field` NVARCHAR(
100 ) NOT NULL
and I get this error message:
ERROR 1064: You have an error in your SQL syntax near 'NVARCHAR( 100
) NOT NULL ' at line 1

Thanks.

"Pack Fan" <pa**@fan.com> wrote in message

news:<vs************@corp.supernews.com>...

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...

Hello.

I'm trying to store UTF-8 texts into a mySQL database. These
texts contains Spanish special characters.

If I set field as VARCHAR and browse stored data, I get 'año'
instead of 'año'.

But if I set field as BLOB, and I perform
SELECT * FROM my_table WHERE my_field LIKE '%año%'
it does not work.

And
SELECT * FROM my_table WHERE my_field LIKE '%año%'
does work.

I would like to be able to work with right words... is it
possible?

Thank you very much.

Try NVARCHAR.

My mistake. I was thinking MSSQL. Sorry.

This might help, though: http://www.mysql.com/doc/en/Charset-Unicode.html