Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Problem with Unicode characters (éàè) in MySQL
sp_NewPost Add Reply sp_NewTopic Add Topic
February 20, 2018
8:00 pm
klorane
Guest
Guests

Thanks Henk,

I think I changed this option when I had PDU problems.

An idea for futur : create backup system for quickly restore the different parameters of diafaan (gateway and connector)

Best regards
klorane

February 19, 2018
3:32 pm
Henk Helmantel
Admin
Forum Posts: 913
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

I see, you probably had set the 'CompatibilityMode' property in the GSM Modem Gateway to 'BasicTextMode'. Basic text mode offers only limited support for the SMS feature set and it does not support sending Unicode characters.

In general it is best to leave the 'CompatibilityMode' property in 'Normal' or 'Enhanced' mode. If the modem does not support one of the AT commands that Diafaan SMS Server requires, it can be set to 'BasicPDUMode'. 'BasicTextMode' should normally only be used for CDMA modems/networks that do not support the GSM SMS standard.

Regards, Henk

February 17, 2018
4:45 pm
klorane
Guest
Guests

Problem solved.

i selected : Compatibiltymode : BasicPDUmode.

It's good.

Klorane

February 16, 2018
6:56 pm
klorane
Guest
Guests

hello Henk

database in : UTF8MB4_general_ci

after i created news tables. i use directly this in my sql :

CREATE TABLE MessageOut (
Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
MessageTo VARCHAR(80),
MessageFrom VARCHAR(80),
MessageText TEXT,
MessageType VARCHAR(80),
Gateway VARCHAR(80),
UserId VARCHAR(80),
UserInfo TEXT,
Priority INT,
Scheduled DATETIME,
ValidityPeriod INT,
IsSent TINYINT(1) NOT NULL DEFAULT 0,
IsRead TINYINT(1) NOT NULL DEFAULT 0) CHARACTER SET utf8mb4;

...

i added : UTF8MB4

Driver={MySQL ODBC 5.3 Unicode driver};Server=XXXXX;charset=UTF8MB4;Database=XXXXXX;User=XXXXXXX;Password=XXXXXX;Option=3;

Résult : ééé=???

I don't know where is problem bacause all is in UTF8MB4 🙁

i can send copy screen of my database by mail

Thanks
Klorane

February 16, 2018
10:17 am
Henk Helmantel
Admin
Forum Posts: 913
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

The Unicode handling of MySQL is a bit tricky, you need the right combination of the database configuration, ODBC driver and connection string and if one of these components is the wrong version or if it is not set up correctly MySQL may convert non-ascii characters to question marks.

You can find an instruction for a MySQL database setup on our website. We used the utf8mb4 character set for the database encoding and in the connection string. The utf8mb4 character set offers support for all Unicode characters.

Regards, Henk

February 15, 2018
2:47 pm
klorane
Guest
Guests

Hello Henk,

i tested :

Driver={MySQL ODBC Unicode 5.3 driver}...........

connection SQL = OK.

but same result: ééé=???

in my sql : MessageText is in utf8_general_ci

Thanks
Klorane

February 15, 2018
10:00 am
Henk Helmantel
Admin
Forum Posts: 913
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Klorane,

You are using the ANSI driver ODBC driver instead of the Unicode driver, to use the Unicode version of the driver you can try the following connection string:

Driver={MySQL ODBC 5.3 driver};Server=XXXXXXx;charset=UTF8;Database=XXXXXX;User=XXXXXX;Password=XXXXXXX;Option=3;

Regards, Henk

February 15, 2018
12:28 am
klorane
Guest
Guests

Hello Henk,

I have a problem with encoding. (éàè...)
My database Mysql is in ut8_general_ci.

This my configutation in diafaan (in connecting string)
Driver={MySQL ODBC 5.3 ANSI driver};Server=XXXXXXx;charset=UTF8;Database=XXXXXX;User=XXXXXX;Password=XXXXXXX;Option=3;

In editorDatabaseCharacterSet : Unicode

when I receive or send message (example: éééé) I receive : ????

Do you know what to change?

Thanks
Klorane

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
11 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 490

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 759

Posts: 2620

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 913