WinSQL » Knowledge base
Document information
Document ID: | 808 |
---|
Subject: | Converting from one data type to another in ODBC |
---|
Creation date: | 7/29/09 4:36 PM |
---|
Last modified on: | 7/29/09 4:36 PM |
---|
Details
ODBC specifications includes a function called CONVERT that can be used
to convert data from one datatype to another. This function is equivalent to
the CAST function defined in SQL-92. The syntax is as follows:
{fn CONVERT (value-exp, data-type) }
Example:
select
{fn
CONVERT
(dob
, SQL_CHAR
)}
from
Student
The second parameter to this function should be a valid ODBC data type. Following list
contains possible values.
- SQL_CHAR
- SQL_VARCHAR
- SQL_LONGVARCHAR
- SQL_DECIMAL
- SQL_NUMERIC
- SQL_SMALLINT
- SQL_INTEGER
- SQL_DOUBLE
- SQL_BINARY
- SQL_VARBINARY
- SQL_TYPE_DATE
- SQL_TYPE_TIME
- SQL_TYPE_TIMESTAMP
User comments
Posted by Rick L on 3/27/12 2:20 PM
To change the Temp file directory for a Syncrify CLIENT machine.
add to/edit C:\ProgramFiles\SyncrifyClient\SyncrifyClient.lax
lax.nl.java.option.additional=-Djava.io.tmpdir=C:\temp
Posted by Richard Maidment on 3/21/19 3:19 AM
You need to be careful with the default temp directory on a QNAP.
Syncrify uses /tmp by default. This directory is actually a ramdisk and is restricted to 64mb in size.
I found that this limit was breached and it caused other issues on the QNAP. In particular the temperature monitoring stopped and the fan monitor reported a failure.
I created a tmp directory off the Syncrify directory as per the article and normality returned.
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.