s***8
发帖数: 1136 | 1 When creating a table with one column type as VARBINARY, got the following
error:
ERROR 42X01: Syntax error: Encountered "" at line 1, column 76.
Issue the 'help' command for general information on IJ command syntax.
Any unrecognized commands are treated as potential SQL commands and executed
directly.
Consult your DBMS server reference documentation for details of the SQL
syntax supported by your server.
IF I change varbinary to varchar, it works. But I need to use varbinary.
Anyone can help? | F****n
发帖数: 3271 | 2 You need to do what the exception suggestion: consult the reference
documentation of the specific DB's SQL.
executed
【在 s***8 的大作中提到】
: When creating a table with one column type as VARBINARY, got the following
: error:
: ERROR 42X01: Syntax error: Encountered "" at line 1, column 76.
: Issue the 'help' command for general information on IJ command syntax.
: Any unrecognized commands are treated as potential SQL commands and executed
: directly.
: Consult your DBMS server reference documentation for details of the SQL
: syntax supported by your server.
: IF I change varbinary to varchar, it works. But I need to use varbinary.
: Anyone can help?
| s***8
发帖数: 1136 | 3 every problem can be solved this way, then let's close this forum. | F****n
发帖数: 3271 | 4 Maybe every problem you faced can by solved this way. Not others. Otherwise
no need to hire people.
【在 s***8 的大作中提到】
: every problem can be solved this way, then let's close this forum.
| T*****e
发帖数: 361 | 5 VARCHAR FOR BIT DATA?
...
JDBC metadata type (java.sql.Types)
VARBINARY
...
http://db.apache.org/derby/docs/10.2/ref/ref-single.html#rrefsqlj32714
I am no Derby expert. The above was the result of a few minutes' search. I
agree with Foxman's statement in this case, for asking others to do your
basic reading may not be a good habit.
However, there is nothing wrong to ask. But don't take it personal when you
are asked to read the manual/reference, which is just a more general answer
to many du
【在 s***8 的大作中提到】
: every problem can be solved this way, then let's close this forum.
| s***8
发帖数: 1136 | 6
Otherwise
Please focus on the tech problem itself, not people. When you say "problem
you faced", I think you cross the line.
I think part of the purpose of these forums are to exchange info, help each
other, and improve all our skills. I appreciate all the help I got on this
and other topics. For those topic that I have experice, I'm happy to share
my knowledge.
For this topic, I did do some research first before posting it, but will
feel more comfortable if some experts can give definitive
【在 F****n 的大作中提到】
: Maybe every problem you faced can by solved this way. Not others. Otherwise
: no need to hire people.
| T*****e
发帖数: 361 | 7 Please take it easy. I guess Foxman did not mean to offend you in any way.
At least I wouldn't consider his statement being offensive.
As you said, you've done some research on this topic already. Why didn't
you simply offer the explanation when Foxman asked you to read the reference
? If I were you, I, as the one asking for help/input here, would probably
be more patient. Further more, providing more explanation/information will
for sure make it a lot easier for others to help.
By the way,
【在 s***8 的大作中提到】
:
: Otherwise
: Please focus on the tech problem itself, not people. When you say "problem
: you faced", I think you cross the line.
: I think part of the purpose of these forums are to exchange info, help each
: other, and improve all our skills. I appreciate all the help I got on this
: and other topics. For those topic that I have experice, I'm happy to share
: my knowledge.
: For this topic, I did do some research first before posting it, but will
: feel more comfortable if some experts can give definitive
| s***8
发帖数: 1136 | 8 Thanks for all the help. |
|
