This is a migrated thread and some comments may be shown as answers.

Skandinavian char support

10 Answers 144 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

10 Answers, 1 is accepted

answered on 13 Jan 2011, 05:51 PM

Hello.

I have tried to use Current Language=Swedish but it's not working. The result is same that open access strip the String.
I try to save street address as "Tegelbruksvägen 2" but get reslut in database after insert "Tegelbruksv".

In microsoft pure linq to sql entities it's working ok without changes to ordinary connectionstring. It's use databse default that is latin1 then i hade made that database. It would be nice if open acces could use database default instead of it's utf8 as default. Now it's working only out of the box in us and english countries but others do get problems. Is there any other way to configure orm to not use default charset utf8.

Hope that telerik could fix this because i like open access orm but if can't get other charset to work i can't use it.

Hope you in telerik can fix this.

Br
Vesa

answered on 17 Jan 2011, 07:47 PM

USE [master]
GO

/****** Object: Database [test] Script Date: 01/17/2011 20:42:34 ******/
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'test_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

ALTER DATABASE [test] SET COMPATIBILITY_LEVEL = 100
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [test].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

ALTER DATABASE [test] SET ANSI_NULL_DEFAULT OFF
GO

ALTER DATABASE [test] SET ANSI_NULLS OFF
GO

ALTER DATABASE [test] SET ANSI_PADDING OFF
GO

ALTER DATABASE [test] SET ANSI_WARNINGS OFF
GO

ALTER DATABASE [test] SET ARITHABORT OFF
GO

ALTER DATABASE [test] SET AUTO_CLOSE OFF
GO

ALTER DATABASE [test] SET AUTO_CREATE_STATISTICS ON
GO

ALTER DATABASE [test] SET AUTO_SHRINK OFF
GO

ALTER DATABASE [test] SET AUTO_UPDATE_STATISTICS ON
GO

ALTER DATABASE [test] SET CURSOR_CLOSE_ON_COMMIT OFF
GO

ALTER DATABASE [test] SET CURSOR_DEFAULT GLOBAL
GO

ALTER DATABASE [test] SET CONCAT_NULL_YIELDS_NULL OFF
GO

ALTER DATABASE [test] SET NUMERIC_ROUNDABORT OFF
GO

ALTER DATABASE [test] SET QUOTED_IDENTIFIER OFF
GO

ALTER DATABASE [test] SET RECURSIVE_TRIGGERS OFF
GO

ALTER DATABASE [test] SET DISABLE_BROKER
GO

ALTER DATABASE [test] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO

ALTER DATABASE [test] SET DATE_CORRELATION_OPTIMIZATION OFF
GO

ALTER DATABASE [test] SET TRUSTWORTHY OFF
GO

ALTER DATABASE [test] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO

ALTER DATABASE [test] SET PARAMETERIZATION SIMPLE
GO

ALTER DATABASE [test] SET READ_COMMITTED_SNAPSHOT OFF
GO

ALTER DATABASE [test] SET HONOR_BROKER_PRIORITY OFF
GO

ALTER DATABASE [test] SET READ_WRITE
GO

ALTER DATABASE [test] SET RECOVERY FULL
GO

ALTER DATABASE [test] SET MULTI_USER
GO

ALTER DATABASE [test] SET PAGE_VERIFY CHECKSUM
GO

ALTER DATABASE [test] SET DB_CHAINING OFF
GO

answered on 17 Jan 2011, 07:49 PM

Database script that makes tables.

USE [test]
GO
/****** Object: Table [dbo].[customer]    Script Date: 01/17/2011 20:49:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[customer](
   [cusid] [varchar](10) NOT NULL,
   [firstname] [varchar](255) NULL,
   [lastname] [varchar](255) NULL,
CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED
(
   [cusid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[teltype]    Script Date: 01/17/2011 20:49:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[teltype](
   [typeid] [int] IDENTITY(1,1) NOT NULL,
   [description] [nchar](10) NOT NULL,
CONSTRAINT [PK_teltype] PRIMARY KEY CLUSTERED
(
   [typeid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[telefone]    Script Date: 01/17/2011 20:49:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[telefone](
   [telid] [uniqueidentifier] NOT NULL,
   [cusid] [varchar](10) NOT NULL,
   [tnumber] [varchar](50) NOT NULL,
   [typeid] [int] NOT NULL,
CONSTRAINT [PK_telefone] PRIMARY KEY CLUSTERED
(
   [telid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[address]    Script Date: 01/17/2011 20:49:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[address](
   [addressid] [int] NOT NULL,
   [cusid] [varchar](10) NOT NULL,
   [street] [nchar](10) NOT NULL,
CONSTRAINT [PK_address] PRIMARY KEY CLUSTERED
(
   [addressid] ASC,
   [cusid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: ForeignKey [FK_address_customer]    Script Date: 01/17/2011 20:49:08 ******/
ALTER TABLE [dbo].[address] WITH CHECK ADD CONSTRAINT [FK_address_customer] FOREIGN KEY([cusid])
REFERENCES [dbo].[customer] ([cusid])
GO
ALTER TABLE [dbo].[address] CHECK CONSTRAINT [FK_address_customer]
GO
/****** Object: ForeignKey [FK_telefone_customer]    Script Date: 01/17/2011 20:49:08 ******/
ALTER TABLE [dbo].[telefone] WITH CHECK ADD CONSTRAINT [FK_telefone_customer] FOREIGN KEY([cusid])
REFERENCES [dbo].[customer] ([cusid])
GO
ALTER TABLE [dbo].[telefone] CHECK CONSTRAINT [FK_telefone_customer]
GO
/****** Object: ForeignKey [FK_telefone_teltype]    Script Date: 01/17/2011 20:49:08 ******/
ALTER TABLE [dbo].[telefone] WITH CHECK ADD CONSTRAINT [FK_telefone_teltype] FOREIGN KEY([typeid])
REFERENCES [dbo].[teltype] ([typeid])
GO
ALTER TABLE [dbo].[telefone] CHECK CONSTRAINT [FK_telefone_teltype]
GO