Forum Replies Created
-
AuthorPosts
-
ShadowMember
And after dropping a field:
ShadowMemberBefore dropping a field:
ShadowMemberBit cannot be BLOB, just BOB because it is definitely not large 😀
ShadowMemberNope, second click is enough, my screenshots are the proof, just I can't upload them to the forum…
ShadowMemberYeah, but I do! 😀 That's what I'm doing right now – coding an app in VB that uses MySql as db server…
ShadowMemberThe 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!
ShadowMemberNo, 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?
ShadowMemberNope, 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…
ShadowMember@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.ShadowMemberThis 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!
ShadowMemberThe 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.
ShadowMemberCharacters are stored as binary values like all data after all…
ShadowMemberBut you can tunnel the connection through an ssh client. Traffic between SQLyog and ssh is plain.
ShadowMemberGreat! 😀
ShadowMemberThat'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