We are using application that has Polish, Croatian, Macedonian and English languages to insert data. When typing ? \ ? from keyboard, in English is displayed as ? \ ? , in Macedonian as ? ж ?, in Croatian as ? ? ?, in Polish as ? ? ?.
When inserting data everything seems to be OK, insert or update is successful, but when previewing data in Grid, Polish character ( ? ) is missing, like it was not inserted, and after editing record also is missing in form. Other languages are OK, characters are displayed correct.
Is this something that is missing from ScriptCase, or it is about the character, windows driver for keyboard ?
Re: Polish character not displayed in grid
Access the Regional settings and make sure if the Polish is UTF-8.
Vitor Jamil
Re: Polish character not displayed in grid
Those setings are set but again same problem !
Re: Polish character not displayed in grid
I have the same problem. I have database MySQL UTF-8 Unicode and collation utf8_polish_ci. In grid I got ? sign instead of polish characters. My project is in Polish UTF-8.
For example I generated simple application in PHPMaker (utf8 encoded) and got proper polish chracters on website. It means that database is correct.
Any suggestion or help?
There is table sql dump (the last row is inserted by SC application)
/*
MySQL Data Transfer
Source Host: localhost
Source Database: medpra
Target Host: localhost
Target Database: medpra
Date: 2010-01-22 12:12:51
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for mpracy
DROP TABLE IF EXISTS mpracy
;
CREATE TABLE mpracy
(
ID
int(11) NOT NULL AUTO_INCREMENT,
NAZWA
char(60) COLLATE utf8_polish_ci DEFAULT
NULL,
USERID
tinyint(4) NOT NULL,
PRIMARY KEY (ID
)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8
COLLATE=utf8_polish_ci;
– Records
INSERT INTO mpracy
VALUES (‘1’, ‘Narodowy Prążek’, ‘1’);
INSERT INTO mpracy
VALUES (‘2’, ‘Sąd Administracyjny’, ‘1’);
INSERT INTO mpracy
VALUES (‘3’, ‘Pomorskie Wały’, ‘1’);
INSERT INTO mpracy
VALUES (‘4’, ‘Hotel MARATON’, ‘1’);
INSERT INTO mpracy
VALUES (‘5’, ‘KATĘĆ’, ‘1’);
INSERT INTO mpracy
VALUES (‘6’, ‘1 Ł?DKA’, ‘1’);
INSERT INTO mpracy
VALUES (‘7’, ‘IWSZĄDKI’, ‘1’);
INSERT INTO mpracy
VALUES (‘8’, ‘WARKA’, ‘1’);
INSERT INTO mpracy
VALUES (‘9’, ‘MOŃKI’, ‘1’);
INSERT INTO mpracy
VALUES (‘10’, ‘K?RCZĄTKO’, ‘1’);
INSERT INTO mpracy
VALUES (‘11’, ‘J?ZEFIĆ’, ‘1’);
INSERT INTO mpracy
VALUES (‘12’, ‘DOM ŁĄKINIA’, ‘1’);
INSERT INTO mpracy
VALUES (‘13’, ‘DOM KŻĄDKI’, ‘1’);
INSERT INTO mpracy
VALUES (‘14’, ‘DOM ŁĄTAWA’, ‘1’);
INSERT INTO mpracy
VALUES (‘15’, ‘WĘZEŁ ŁĄCZNOŚCI’, ‘1’);
INSERT INTO mpracy
VALUES (‘16’, ‘KOMENDA WĄWOZU’, ‘1’);
INSERT INTO mpracy
VALUES (‘17’, ‘DOW?DZTWO REGIONU’, ‘1’);
INSERT INTO mpracy
VALUES (‘18’, ‘JW 1199’, ‘1’);
INSERT INTO mpracy
VALUES (‘19’, ‘DOMEK KRĘCONY’, ‘1’);
INSERT INTO mpracy
VALUES (‘20’, ‘Środą jętżźćŹĆŃŁ’, ‘1’);