Support forum
Add Reply
Add Topic8:00 pm
QuoteThanks 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
3:32 pm
May 28, 2013
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
4:45 pm
Problem solved.
i selected : Compatibiltymode : BasicPDUmode.
It's good.
Klorane
6:56 pm
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
10:17 am
May 28, 2013
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
2:47 pm
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
10:00 am
May 28, 2013
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
12:28 am
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
Most Users Ever Online: 529
Currently Online:
5 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 680
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1156
Posts: 3946
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1511