Mysql language error

[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.

[kgnet202 (Foysal Ahmed)]

Thanks To @Taifun, @Rogerio_Rios, @Zia_Choudhary and all who helped me to solve this problem…
My language problem was fixed perfectly.
Love u all.

[Taifun]

@kgnet202

My language problem was fixed perfectly.

great to hear
you might want to provide a short summary about the steps you did to solve the problem
this might help others with the same problem in future
thank you

Taifun

[Zia_Choudhary (Zia Ur Rahman)]

U r most welcome
And it will be very helpful for community if you provide the solution as @Taifun mentioned above

[darwin_bark]

use
’ enter your table name ’ ie you have to give either table is numeric or varchar