1

In my .sql file is like as below,

INSERT INTO `BtoB` (`ID`,`cWord`,`cMean`) VALUES (1, 'A', 'Av`¨¯^i| eY©gvjvi cÖ_g eY©|');
INSERT INTO `BtoB` (`ID`,`cWord`,`cMean`) VALUES (2, 'A2', 'bT&Zrcyi“l mgv‡m bT& ¯’v‡b A nq|');
INSERT INTO `BtoB` (`ID`,`cWord`,`cMean`) VALUES (3, 'A', 'Afve, AmyL, A‡eva, AKvj, AeªvþY, Aag©|');

In manually, when I have converted it the 'cMean' column value then it would be like as below,

enter image description here

I don't like to ASCII string in the 'cMean' column value. I would like to 'cMean' column value should be Bangla string. Already I have assigned the database table 'cMean' column collection type is 'utf8_general_ci'. I would like to create a method or process in php or anything automatic system to convert the ASCII string to Bangla string that why 'cMean' column value must be store is as a bangla string. I have used MySQL database.

Now how can I store 'cMean' column data value is as Bangla string in the table?

Damini Suthar
  • 1,386
  • 2
  • 9
  • 34
Optimus Prime
  • 276
  • 6
  • 20

2 Answers2

1

There is no "Ascii" for Bangla. What you have is "Mojibake", which is a misinterpretation of UTF-8 encoding.

You need to set utf8 at multiple places to avoid it. See "best practice" and "Mojibake" in Trouble with UTF-8 characters; what I see is not what I stored

Perhaps you mean Bengali? I see that অব in utf8 is hex E0A685 E0A6AC. However, Mojibake (with latin1) would give you অব

Rick James
  • 122,779
  • 10
  • 116
  • 195
0

Make the 'cMean' column Character Set: utf8 and Collation utf8_general_ci or utf8_unicode_ci

It should work then.

slon
  • 986
  • 1
  • 7
  • 12