I currently am trying to synchronize a remote FoxPro database with a local SQL Server 2000 database. I am running across a memo (binary) data type in the FoxPro database. Up until today I have been using the SQL command "Convert(varchar(8000),CONVERT(varbinary(8000),frm_data))" and this is fine if the memo field isn't longer than 8000 characters. Well, today I ran across one that was 2,000 characters. My little work around so far has been to bring it into my .NET application and convert each byte into a character and then save those to a string. Is there a better way to do this using an SQL statement
FoxPro Image to SQL Char
Hot Topic
- SA account Locked out
- Execute Mutiple Tasks In Debug Mode
- SSIS packages in registry?
- Scheduling a legacy DTS package
- Knowing what is grouped?!
- SQL Server connection from C#/asp.net
- SSIS package configuration issue
- Comparing VarCHAR FIELD with NULL
- Register a Sql Server 2000 database from Sql Server 2005
- How to Install SSIS
SQL Server
- deploy to another server
- Moving a SQL2K publisher to a SQL 2005 instance.
- Directly editing data in results pane with SQL 2005 Management Studio
- How to export data from stored procedure source?
- Newbie questions with mySQL
- Error in Scheduling SSIS Package
- In cursor: help to perform proper comparison using variable
- Create SSRS 2005 snapshot programically
- Random variable modeling using T-SQL
- How to run an exe in the SSIS scripting task
FoxPro Image to SQL Char