[peterlaursen]

If there is no value is displays “(NULL)” and “O KB”.

If the value is a few hundred bytes only it displays beginning_of_TEXT or “(binary/Image)” and “O KB”.

I honestly don't know if it TRUNCATES or ROUNDS when getting data size – or put another way, if it's size must exceed ½ KB or 1 KB not to display as “0 KB”

[peterlaursen]

Am I wrong thinking that it was you that requested a select all/unselect all functionality in the ODBC wizard ?

[peterlaursen]

@rbma

The failure to read SQL_WHERE is fixed in beta6.

You also had your select/unselect all request …

I think it would be nice if you confirmed the fix!

[peterlaursen]

QUOTE

I put in the value “00:08:25” for instance.

How did you input it and what does SQLyog (and you could try command-line client too) say that the value is ?

I shall not say anything more (it is more then 10 years ago that I have been coding myself except for some HTML and the like) but just came across this discussion thread in the MySQL forums where typechecking issues in JDBC compared to ODBC was discussed in relation to Coldfusion.

[peterlaursen]

SQLyog GUI beta5 has a problem parsing/displaying a SQL_WHERE from an XML-file.

Is there more to it now? Or is it reduced to this?

[peterlaursen]

Quote:

Also can't overwrite an existing saved session.

I cant reproduce this problem! It works fine here!

there is not a SJA-process running in background (check taskmanager)

[peterlaursen]

Quote:

The value in the 'SQL Where' doesn't show up when editing a saved session

That's the same here with Beta5 – SQLWHERE does not show up in SQLyog GUI.

But if you edit XML-file in Notepad and execute it from commandline does it then work as it should ?

[peterlaursen]

I find only length statements like

Quote:

10

which program did you use for editing ?

how does Notepad or another simple texteditor display the file ?

If it displays OK in Notepad, then try saving it from here.

[peterlaursen]

QUOTE

Everything appeared to have non-null values in SQLYog

then I believe that something went wrong when you entered data!

One of the google results point of an important difference between ODBC and JDBC – that is that type checking is much stronger in JDBC. Values like 0000-00-00 and 2005-13-37 would never be acceptepted by JDBC as a legal value for DATE. The result of an attempt to enter such data would leave the DB values as NULL.

Equally JDBC will not accept 99-99-99 as TIME (hours-minutes-seconds)

[peterlaursen]

BTW

there might be something here that you can use:

http://www.google.com/search?q=coldfusion+…=utf-8&oe=utf-8

[peterlaursen]

to run it just …

Quote:

sja jobfile.xml

after the system shell prompt.

But what are we talking about ?

How to execute SJA?

Or how to build a jobfile?

Or is it (still?) an installatation problem?

You won't get precise answers unless you ask precise questions!

But I believe I can figure out now that you want to run the MySQL client SJA on a Linux-machine …

[peterlaursen]

QUOTE

and it is returning an empty string

Good question is then: Does the database contain

1) time-values that makes sense ?

2) empty strings ?

3) NULL-values ??

What does SQLyog show when viewing data from DATA or RESULT-tab ?

TIMESTAMP(14) and DATETIME variables in MySQL are basically 14-character strings (that is how it is implemented with the database itself), but a client should be “smart” enough to distinguish between a string having a TIME-meaning and any other string. In a scripting language you should choose an appropriate method and language variable type.

I don't know enough about coldfusion to tell whether it has problems with MySQL TIME-variable types. But first of all chece that the data in the DB are as they should be!

[peterlaursen]

QUOTE

I want to make 2 'roots' on one computer if that is possible

I am not quite sure that I understand! But users are created with the MySQL server(s), not with clients. I you want to run some client software (such as SQLyog) you can connct to as many MySQL servers as the ROOT-user on each respective server as you want.

I believe you want to install and run a complete server-“lineup” like a webseerver, php and MySQL at a local machine for development. However, then I don't see the problem!

I suggest that you explain more in detail …

[peterlaursen]

Quote:

I've downloaded it and am now trying to install it

Are you using SJA on Linux or SQLyog on Windows ??

This is a question on which platform you run the client software! The server may run on any platform on which MySQL can run! So you can run SQLyog on windows and connect to to a MySQL server running on Linux without any problems:

[peterlaursen]

Quote:

I think that this issue is not going anywhere

At least here we agree! To get closer simply more information is needed! And no one seems to be able to find the “key” to that information.

But remeber: Ritesh was not able to reproduce the error with the same query and you data.

I would not mind testing too and a lot of people probably would not either …

Nobody else reported something similar. And I don't believe the querries are unusually complex.

[Author]

Posts