Mysql language error

[Lalit_prasad1 (Lalit prasad)]

can u post block cant get idea whats happening without seeing block

[kgnet202 (Foysal Ahmed)]

[kgnet202 (Foysal Ahmed)]

@Lalit_prasad1
I also get this error in @Taifun MySQL queries.

[Taifun]

@kgnet202 did you set
mysqli_set_charset($conn, "utf8");
see also

Problems with international characters

well… obviously in the php script… for example like this after creating the connection $conn = new mysqli($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME); mysqli_set_charset($conn, "utf8"); if($conn->connect_error){ ... Taifun

Taifun

[Mateja]

Btw, question about deephost’s extensions are not allowed.

[Zia_Choudhary (Zia Ur Rahman)]

@kgnet202

Thank you brthr…

hi
Try this block from web componet to encode your data (that you want to save in database)

this is used to encode and whgen you get data from database then use another block named ad Url decaoder to decode your data .
try this and let me know if its causing any problms

[kgnet202 (Foysal Ahmed)]

it also shows the same error…

[kgnet202 (Foysal Ahmed)]

am I insert the code in right place?

mysqlkgnet.php

[Rogerio_Rios (Professional Support)]

Insert right after creating a connection.
$dbc or $conn ?

[Rogerio_Rios (Professional Support)]

Try alter your table or column :

ALTER Table YourTableName Modify YourColumnName FieldType(LenghtField) Character Set utf8 COLLATE utf8_unicode_ci

ALTER TABLE YourTableName Convert To Character SET utf8 COLLATE utf8_unicode_ci

And your Database :

ALTER Database YourDataBaseName Convert To CHARACTER SET utf8 COLLATE utf8_unicode_ci

And in the create table put at the end after closing the parenthesis ENGINE = InnoDB DEFAULT CHARSET = utf8;

[Yash_Agarwal_376 (Yash aggarwal)]

Are u using deephost extension ? Or any other

[Taifun]

@kgnet202

am I insert the code in right place

yes, but you are using the wrong varible name as @Rogerio_Rios already mentioned
you might want to read again my previous answer and follow the provided link…

Problems with international characters

well… obviously in the php script… for example like this after creating the connection $conn = new mysqli($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME); mysqli_set_charset($conn, "utf8"); if($conn->connect_error){ ... Taifun

Taifun

[kgnet202 (Foysal Ahmed)]

I an using Taifun’s MySQL query.

[Taifun]

@kgnet202

I an using Taifun’s MySQL

ok fine… and what happens after fixing your variable name?
Taifun

[kgnet202 (Foysal Ahmed)]

Hlw @Taifun, when I fix my variable name to conn then I can insert data or create a table but the problem is that my inserted data shows as some symbols. I can’t see the real inserted data. So now how can I solve this problem?

this is my php script mysqlkgnet (1).php - Google Drive

[Rogerio_Rios (Professional Support)]

@Rogerio_Rios

Try alter your table or column :

ALTER Table YourTableName Modify YourColumnName FieldType(LenghtField) Character Set utf8 COLLATE utf8_unicode_ci

ALTER TABLE YourTableName Convert To Character SET utf8 COLLATE utf8_unicode_ci

And your Database :

ALTER Database YourDataBaseName Convert To CHARACTER SET utf8 COLLATE utf8_unicode_ci

And in the create table put at the end after closing the parenthesis ENGINE = InnoDB DEFAULT CHARSET = utf8;

Did You try ?

[kgnet202 (Foysal Ahmed)]

I didn’t understand.

[Rogerio_Rios (Professional Support)]

Run these commands on phpmyadmin. And change to the name of your database, table and Fields

[kgnet202 (Foysal Ahmed)]

[Rogerio_Rios (Professional Support)]

There is an SQL tab, where you execute the commands entered. Like those I mentioned.