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?
Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our
public forums to post questions.
