[google-cloud-sql-discuss] Re: Data is garbled when importing CSV to SQL instance

SQL Server and Cloud SQL do not support CSV files. As already indicated, SQL Server presently supports importing databases using BAK and SQL files in Cloud SQL.

The Cloud SQL versions for MySQL and PostgreSQL somehow support it.

One of the following options is possible:

Alternatively, switch to MySQL or PostgreSQL as the database engine (where CSV files are supported).

You can utilize your CSV file to create a SQL file that you may use to import into Cloud SQL, SQL Server, if the data on it comes from an on-premises SQL Server DB table.

On Monday, July 4, 2022 at 3:04:10 PM UTC-5 airflo...@gmail.com wrote:

Hello,

    I have been trying to import a CSV file to GCP SQL Instance, PFA a screenshot of the part of the SQL File. Import is showing as successful, I tried both using the UI and gcp sql import command but same result for both. PFA SELECT * command from the table.

    Please let me know what I am doing wrong, and if you need any more information.

Thanks and Regards,

Shashanka

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a2976065-3142-4c08-9e67-b5b92d0035a6n%40googlegroups.com.