Getting nulls when nserting Mysql values into sqlite special characters

M

m643

Member
Licensed User
Longtime User
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?
 
Sort by date Sort by votes
M

m643

Member
Licensed User
Longtime User
Erel said:
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.
Click to expand...

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

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

mc73

Well-Known Member
Licensed User
Longtime User
In my php I had to set
B4X: 
mysql_query( "SET NAMES utf8", $con);
mysql_query( "SET CHARACTER SET utf8", $con);
Worked for me.
 
Upvote 0
M

m643

Member
Licensed User
Longtime User
mc73 said:
In my php I had to set
B4X: 
mysql_query( "SET NAMES utf8", $con);
mysql_query( "SET CHARACTER SET utf8", $con);
Worked for me.
Click to expand...

I tried this but still getting nulls. How do you create the columns in sqlite, just "plot TEXT"?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

M
  • Question
Android Question MySQL via JDBC and Special Charter (UTF8)
Replies
7
Views
1K
mw71
M
  • Question
Android Question Error when SetHeaders HttpJob with Special Characters 'Ñ'
Replies
2
Views
2K
scsjc
  • Article
B4A Library SD: SqliteExtra
2
Replies
28
Views
9K
Johan Hormaza
  • Question
Android Question sqlite not reading special characters
Replies
6
Views
4K
Mahares
M
  • Article
Android Tutorial Complete tutorial: B4A & Your own (local) php & MySql Server (Xampp) with b4a
2
Replies
36
Views
43K
OliverA
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…