Getting nulls when nserting Mysql values into sqlite special characters

[m643]

Hi,

I'm trying to insert some text with special characters like éé or ë into my sqlite db (column=plot TEXT). Problem is that it saves null values when the text containts special characters. In my mysql database the field has utf8 as collation.

How can I solve this?

 

[Erel]

Have you added the PHP line that sets the encoding to UTF8? It is a single line that you need to add to the PHP script. I've added it in the MySQL tutorial.

 

[m643]

Have you added the PHP line that sets the encoding to UTF8? It is a single line that you need to add to the PHP script. I've added it in the MySQL tutorial.

Do you mean the line in the query: mysql_query("SET CHARACTER SET utf8");?

I also tried $string= utf8_encode ( $plot);

 

[Erel]

Yes: http://www.b4x.com/forum/basic4andr...nnect-android-mysql-database-tutorial-27.html

 

[m643]

Yes: http://www.b4x.com/forum/basic4andr...nnect-android-mysql-database-tutorial-27.html

Hi Erel,

I added mysql_query("SET CHARACTER SET utf8"); I deleted all the data in my mysql db, convert all columns to utf8 and loaded the data again. But still get nulls in my sqlite db. :sign0085:

 

[mc73]

In my php I had to set

mysql_query( "SET NAMES utf8", $con);
mysql_query( "SET CHARACTER SET utf8", $con);

Worked for me.

 

[m643]

In my php I had to set

mysql_query( "SET NAMES utf8", $con);
mysql_query( "SET CHARACTER SET utf8", $con);

Worked for me.

I tried this but still getting nulls. How do you create the columns in sqlite, just "plot TEXT"?

 

[mc73]

I tried this but still getting nulls. How do you create the columns in sqlite, just "plot TEXT"?

Yes.

How did you create your mysql tables? Sure about their encoding?