UTF8 problem

[dugasz1]

Hi! I need to use utf8 characters because my language (for example : á,é,ő)

My problem is if in a field there is a accent character i will get a deficient value:

In the mysql: Vadász --> I will get: Vad

or: Kerék --> Ker

Any idea?

[WhoAmI]

string.find

[dugasz1]

You dont understand me, i dont wanan find the query result its deficient :

The real value for example: Vadász --> I will get: Vad

[Cadu12]

Problem is the MySQL.

http://bitnami.com/forums/forums/lampst ... 8-in-mysql

[dugasz1]

Thanks i will try

[dugasz1]

My problem solved. I runed this and now its ok:

dbExec( theMysql,"SET NAMES utf8" ) 

Somebody can exmpain what i did?

[Citizen]

You just changed the encoding type of the communications between your script and the sql server to UTF-8 for the current connection (theMysql).

Because ASCII encoding can't handle your special characters.

[dugasz1]

Thank you !

And can i set it on my mysql server to be the default communication?

[Citizen]

1 - Log into phpMyAdmin.

2 - Select your database.

3 - Click on "Operations" from the top set of tabs.

4 - In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation/encoding.

5 - Click on Execute/Run button.

And then you need to repeat the same operations but on all tables already created (which doesn't have the right collation/encoding).

(And maybe for columns of all tables, not sure if they will be updated)

The next tables you will create will get the database collation as default so you will be ok.

[dugasz1]

Thank you so much !