Active Directory, AS/400, Business Intelligence, CIO, Cisco, Database, DataCenter, Desktops, Development, DNS, Exchange, Exchange 2003, Exchange 2007, Hardware, iSeries, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
Hi, m getting an Error when m converting a charater type to a numeric type ie to int or float through ALTER COLUMN command ERROR IS: Cannot convert a char value to money. The char value has incorrect syntax. The statement has been terminated.
We currently have an instance in use that has the characterset of US7ASCII. The vendor of the application running on that instance has suggested we change to WE8MSWIN1252. do you think that any data could get corrupted when going from a 7-bit characterset to the 8-bit one and can we do this in...