显示标签为“care”的博文。显示所有博文
显示标签为“care”的博文。显示所有博文

2012年3月11日星期日

BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE

I NEED TO BCP DATA FROM A TABLE TO BE COMPLIANT WITH THE

ISO-8859-1 (ISO-LATIN-1) TYPEFACE

IS THERE A SWITCH I CAN USE TO TAKE CARE OF THIS.

EMAD

I am not sure what you mean by compliance with ISO-LATIN-1. If your column collation is specified correctly then BCP will automatically preserve that upon export. So when you create the data file you should get the characters exported correctly. BCP also has the -C option where you can specify the code page used for character translation explicitly but this parameter is meant for backward compatibility purposes.