microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 904 forks source link

sql studio save sql file use azure data studio open Garbled code #24417

Open lozn00 opened 1 year ago

lozn00 commented 1 year ago

Type: Bug

里面包含了一些中文字符,sql studio 保存的,但是使用azure data studio打开时 不能识别文件编码 It contains some Chinese characters saved by SQL Studio, but the file encoding cannot be recognized when opened using Azure Data Studio

Azure Data Studio version: azuredatastudio 1.45.1 (88c21b1725a3e79440027bdb7b5a55fb036be0e2, 2023-08-03T00:42:37.945Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i5-11400 @ 2.60GHz (12 x 2592)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|31.77GB (17.95GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (7) Extension|Author (truncated)|Version ---|---|--- StoredProcedureConverter|loz|0.0.1 ads-language-pack-zh-hans|Mic|1.45.0 asde-deployment|Mic|0.4.1 datavirtualization|Mic|1.13.2 machine-learning|Mic|0.12.0 query-history|Mic|0.5.3 vscodeintellicode|Vis|1.2.1
lozn00 commented 1 year ago

The encoding of the file is gb2312, and it is normal to open it using Microsoft's built-in Notepad

cssuh commented 1 year ago

Is this a .sql file?

cheenamalhotra commented 1 year ago

@lozn00 Can you please check if this issue is still reproducible in latest insiders build.