forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Accentuation Of The Fields Disappearing…
- This topic is empty.
-
AuthorPosts
-
-
June 6, 2007 at 11:28 am #10366ShadowRSMMember
-
June 6, 2007 at 11:41 am #24120peterlaursenParticipant
did you see this one?
http://www.webyog.com/forums//index.php?showtopic=3274
the questions taht we asked here you should answer too!
1) server version?
2) the returns of ” SHOW VARIABLES LIKE '%character%'; “
3) please dump a small table with such data, zip it and attch it here
-
June 6, 2007 at 11:44 am #24121vygiMember
Looks similar to my issue from the prevous thread: http://www.webyog.com/forums//index.php?showtopic=3274
I also had “Österreich” in the table but just “sterreich” on the screen.
Could you please tell us which MySQL version is used (5 or 4/4.1), and if the problem can be (temporarily) fixed by restarting of SQLyog (or starting of new instance)?
-
June 6, 2007 at 11:54 am #24122ShadowRSMMember
1) Server version is: 4.0.20
2) String of SQL for find: SELECT * FROM tblimovel WHERE UPPER(endereco) LIKE UPPER('sao sebastiao%')
3) Attached file 🙂
-
June 6, 2007 at 12:55 pm #24123peterlaursenParticipant
As your server is 4.0 is is another problem. we do not 'SET NAMES' with 4.0
Still I would like if you executed ” SHOW VARIABLES LIKE '%character%'; “
I tried to import your dump to a 4.0 and 5.0 server. In 5.0 both DATA tab and RESULT tab display Ok, in 4.0 some of the special characters become squares in RESULT – in DATA tab it is OK. So my system recognizes the existence of a character, but cannot display it (but in RESULT only – it displays in DATA!)
Default charset for both servers is 'latin1' and both imports where created with that (no charset spec in the dump file).
Danish Windows Vista.
Please also explain the query “SELECT * FROM tblimovel WHERE UPPER(endereco) LIKE UPPER('sao sebastiao%')”
why the UPPER() function? and why LIKE UPPER('sao sebastiao%') and not LIKE UPPER('sao sebastião%')?
-
June 6, 2007 at 1:13 pm #24124peterlaursenParticipant
first image is MySQL 5.0.41 and second image is 4.0.26.
BTW: I would like to know the language of your Windows too!?
-
June 6, 2007 at 1:31 pm #24125peterlaursenParticipant
Also the 'mysql' client cannot display those data correctly on my system (probably because my Windows is anotehr language9
From the cmd line dialogue (and it really displays like that in cmd line!):
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6 to server version: 4.0.26-debug-log
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use uniaosoc
Database changed
mysql> SELECT * FROM tblimovel WHERE UPPER(endereco) LIKE UPPER('sao sebastiao%'
);
+
+
+
+
+
+
+
+
+–
+
+
+
+
+
+
+| iseq | tipo | bairro | conta | lograd | endereco | numero | complem | d
escricao
| aluguel | vago | iptu | condom | rateio | foto |
+
+
+
+
+
+
+
+
+–
+
+
+
+
+
+
+| 3 | 2 | 9 | 62 | Rua | SÒo SebastiÒo | 698 | apto 400 | T
rÛs dormit¾rios com armßrios sendo uma suÝte com box e gabinete, banheiro social
com box e gabinete, lavabo, sala dois ambientes, cozinha com gabinete e armßrio
s, dependÛncia para empregada, ßrea de serviþo e garagem para um veÝculo.
| 600.00 | N | S | S | NULL | NULL |
| 106 | 4 | 9 | NULL | Rua | SÒo SebastiÒo | NULL | NULL | S
ala com divis¾ria e banheiro coletivo.
| 100.00 | S | S | S | NULL | NULL |
| 107 | 4 | 9 | NULL | Rua | SÒo SebastiÒo | NULL | NULL | S
ala com metragem: 3,00 x 9,00mâ–“ e banheiro privativo.
| 250.00 | S | S | S | NULL | NULL |
| 112 | 4 | 9 | NULL | Rua | SÒo SebastiÒo | NULL | sala 23 | S
ala com metragem 5,50 x 4,00mâ–“ com uma divis¾ria para recepþÒo.
| 130.00 | S | S | S | NULL | NULL |
| 119 | 4 | 9 | 75 | Rua | SÒo SebastiÒo | 818 | sala 01-A | Q
uatro salas medindo 4,00 x 4,00mâ–“ sendo duas com ar condicionado e uma com banhe
iro privativo com box e gabinete, uma cozinha com gabinete e dois banheiros.
| 400.00 | N | S | NULL | S | NULL |
| 180 | 3 | 9 | NULL | Rua | SÒo SebastiÒo | NULL | NULL | D
uas portas de aþo, quatro salas na parte superior com sacada, sala na parte infe
rior, banheiro, cozinha e metragem de 5,00 x 9,00mâ–“.
| 0.00 | N | S | NULL | NULL | NULL |
| 183 | 3 | 9 | 448 | Rua | SÒo SebastiÒo | 506 | sala 10 | S
ala com metragem de 26,00mâ–“ e banheiro privativo.
| 250.00 | S | S | S | NULL | S |
| 192 | 3 | 9 | 857 | Rua | SÒo SebastiÒo | 1447 | NULL | U
ma porta de aþo, banheiro, cozinha, quinta pequeno e metragem de 4,00 x 6,00mâ–“.
| 330.00 | N | S | NULL | NULL | NULL |
| 519 | 2 | 9 | 62 | Rua | SÒo SebastiÒo | 919 | apto 71 | T
rÛs dormit¾rios com armßrios um suÝte com box e gabinete sendo um deles reversÝv
el, banheiro social com box e gabinete, sala ampla, sacada, hall com armßrio, co
zinha com armßrio e gabinete, banheiro de serviþo, ßrea de serviþo e vaga para u
m veÝculo. | 650.00 | N | S | S | NULL | S |
+
+
+
+
+
+
+
+
+–
+
+
+
+
+
+
+9 rows in set (0.01 sec)
-
June 6, 2007 at 1:41 pm #24126peterlaursenParticipant
MySQL 4.0.26 and SQLyog 5.32 display correct in both DATA and RESULT tab ('default' chosen in connection manager).
so something seems to be broken in RESULT tab when retrieving data from servers where SET NAMES dosn't apply!
-
June 6, 2007 at 2:01 pm #24127peterlaursenParticipant
At our Office we were able to reproduce missimg charcater just like you reported using an US-English Windows XP.
Fixing this is high priority!
-
June 6, 2007 at 3:32 pm #24128ShadowRSMMember
Thank friend, I wait that this problem is resolved and that they continue with the excellent work in developing this tool!
-
June 6, 2007 at 3:46 pm #24129peterlaursenParticipant
bug is confirmed and fixed and we wil release version 6.02 RC in a few minutes. Please confirm the fix!
-
June 6, 2007 at 7:29 pm #24130ShadowRSMMember
Hello I make friends, before all I forgive for myself for only now to manage to test his piece of news release, I tell them to myself what now release 6.02 RC is working perfectly with the accentuations…
Very obliged friend for the speed and efficiency in repairing the mistake 🙂
-
June 6, 2007 at 8:25 pm #24131ShadowRSMMember
I make friends, fields of the type longtext sometimes it appears the characters or sometimes they all the text in this field are left without the accented characters longtext I do not know when that happens, me always when you do an inquiry and enter in the field longtext the fact is that this bug happens
-
June 6, 2007 at 8:34 pm #24132peterlaursenParticipant
please clarify: Are you telling that you still (6.02 RC) experience the same problem with LONGTEXT data?
-
June 12, 2007 at 11:06 am #24133ShadowRSMMember
Hello I make friends, the mistake is happening in any field that contains accentuation, in other words, he sometimes does not save in the database the characters with accentuation and also when you key in a field that contains accentuation and use the key TAB to go to the near field, the previous field with accentuation it becomes a character without visibility.
-
June 12, 2007 at 12:34 pm #24134peterlaursenParticipant
what is it you call 'accentuation' ? like this: ” á ” ?
we just dicovered another issue with the 'portuguese tilde accented a' ( ã ) in column names and when updating from the RESULT tab.
So we will check for more such issues now!
-
June 13, 2007 at 3:21 pm #24135adarshMember
hello again
we believe we fixed this now. Please download from
1 community link : http://www.webyog.com/downloads/betas/not_…d/SQLyog603.exe
2 trial link : http://www.webyog.com/downloads/betas/not_…603EntTrial.exe
3 enterprise link : http://www.webyog.com/downloads/betas/not_…QLyog603Ent.exe
Please confirm the fix as soon as possible.
We would also very much appreciate a statement
from users using MySQL 3.23 or 4.0 with non-latin1 charsets
whether they have experienced any problems in the character display!
Thanks
-
June 14, 2007 at 11:32 am #24136ShadowRSMMember
Hello friend,
the problem persists still, in other words, when I enter in a field longtext to key in the accented characters they appear so:
And when I am going to pass for another field of publication using the key TAB, the result of the previous field with accentuation appears in this way!
I realize also friend, what when I am going to check the historical of the operations that were effectuated, he was believing a string of UPDATE with the next characters in the accentuation!
Remembering that I am in Result mode for publication, I sincerely do not know if in the Table Data mode the process also happens again!
Tips:
Given correctly of the text for inclusion in the database:
Dois dormitórios, banheiro social com box, sala, cozinha com revestimento e gabinete, área de serviço, abrigo para um veículo com portão automatizado.
Parte superior com banheiro de serviço.
Using:
SQLyog version 6.03 Beta 1
MySQL 4.0.20
-
June 14, 2007 at 11:35 am #24137peterlaursenParticipant
We know there still is an issue in 5.03 beta1. That was also listed as a 'known issue' in the release notes.
Please try the latest non-released build (version no. “5.03 beta2n” – n means 'nonreleased build')
links:
1 community link : http://www.webyog.com/downloads/betas/not_…d/SQLyog603.exe
2 trial link : http://www.webyog.com/downloads/betas/not_…603EntTrial.exe
3 enterprise link : http://www.webyog.com/downloads/betas/not_…QLyog603Ent.exe
-
June 14, 2007 at 11:59 am #24138ShadowRSMMemberpeterlaursen wrote on Jun 14 2007, 08:35 AM:We know there still is an issue in 5.03 beta1. That was also listed as a 'known issue' in the release notes.
Please try the latest non-released build (version no. “5.03 beta2n” – n means 'nonreleased build')
links:
1 community link : http://www.webyog.com/downloads/betas/not_…d/SQLyog603.exe
2 trial link : http://www.webyog.com/downloads/betas/not_…603EntTrial.exe
3 enterprise link : http://www.webyog.com/downloads/betas/not_…QLyog603Ent.exe
Please see this post:
http://www.webyog.com/forums//index.php?s=…ost&p=13935
The Beta 2 nothing downloading… 🙁
-
June 14, 2007 at 12:30 pm #24139
-
June 14, 2007 at 1:00 pm #24140ShadowRSMMember
Hello friend,
I tested and tested it several times SQLYog v6.03 Beta 2 n and the problems with accentuation both in Result Mode and in Date Table are not happening any more 😆
-
June 14, 2007 at 1:24 pm #24141peterlaursenParticipant
Thanks for your report. We will now go ahead and release beta2 officially!
That will be tomorrow probably!
-
-
AuthorPosts
- You must be logged in to reply to this topic.