Forum Replies Created
-
AuthorPosts
-
Shadow
MemberAnd after dropping a field:
Shadow
MemberBefore dropping a field:
Shadow
MemberBit cannot be BLOB, just BOB because it is definitely not large 😀
Shadow
MemberNope, second click is enough, my screenshots are the proof, just I can't upload them to the forum…
Shadow
MemberYeah, but I do! 😀 That's what I'm doing right now – coding an app in VB that uses MySql as db server…
Shadow
MemberThe funny thin is that Hungarian alphabet also contains special characters (ö, ü – like German), however, I use latin1 with Swedish collation just as Peterlaursen does and I have no problem with that. But other developers do suffer a lot with encoding issues… The real problem is that you may set different encodings for you db, db connection, queries, os, HTML page, so I can't really tell which one goes wrong when a character is not displayed correctly!
Shadow
MemberNo, you should not have used the other topic, you were only pointed to that one…
I still don't get it! Why can't you save those frequently needed queries to your personal folder?
Shadow
MemberNope, it does not. That thread merely contains some brainstorming about personal folders. To be honest, my SQL window is usually polluted with all kinds of SQL statements that do not need to be saved. Besides, how do you want SQLyog to save the contents of SQL window? All queries in a single file? Each query in a separate? No, I don't think this is such a good idea…
Shadow
Member@peterlaursen: Yes, I run all kinds of software running along SQLyog 😀 Outlook 2003 for example, but I don't think that would interfere with this inconvenience.
@Ritesh: That explains! I'll mail you the screenshots later today.Shadow
MemberThis may be a character encoding issue: SQLyog's connection charset may differ from that of strored data. Issue a “SET NAMES charset_name” command from SQL window and query your database afterwards. Hope, you'll see the special german characters show up normally!
Shadow
MemberThe whole problem is results from not reading ADO reference… Recordset object's Update() method does not need to be called after changing a field's value! It commits changes made since the last AddNew() call (INSERT statement…)! In case of ADO, changing a filed's value is automatic, just assign a new value and ADO will take care of the rest.
Shadow
MemberCharacters are stored as binary values like all data after all…
Shadow
MemberBut you can tunnel the connection through an ssh client. Traffic between SQLyog and ssh is plain.
Shadow
MemberGreat! 😀
Shadow
MemberThat's very true, Ritesh! Personal folder should be located under the user's documents and setting folder on NT based OS – perhaps in Application Data.
-
AuthorPosts