Mysql language error

[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

[darwin_bark]

correct format

[Rogerio_Rios (Professional Support)]

@Taifun

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

Good that we help you! The above @Taifun tip is very important for the Kodular community.