Database Discussion Boards

mehrdadc4817-Nov-10 20:53

17-Nov-10 20:53

Hi,
I'm developing a multilanguage web site.(My DB is SQL Server 2008 R2)
Some of its languages are: Chinease, Japanesae, Arabic, Persian, English ....
I know about some collation and datatypes in SqlServer, but I'm ambigious about Collation of DB and about char types.
1. What collation I shoud use for my DB?
2. for char types I shoud use varchar or nvarchar?
Thanks for your attention.

Best wishes

Re: Db for multilanguage

Eddy Vluggen18-Nov-10 10:02

Eddy Vluggen

18-Nov-10 10:02

Mixing cultures in a database are a recipe for severe headache's.

mehrdadc48 wrote:
What collation I shoud use for my DB?

The appropriate one for the required sort-method (binary or dictionary? case sensitive, or not?) for the language, they're listed here[^].

mehrdadc48 wrote:
for char types I shoud use varchar or nvarchar?

NVARCHAR, NTEXT and/or NCHAR.

Important note;

txt

Windows Unicode-only collations can only be used with the COLLATE clause to apply collations
to the nchar, nvarchar, and ntext data types on column-level and expression-level data; they 
cannot be used with the COLLATE clause to change the collation of a database or server instance.

Says so here[^]. That page also mentions that there's three different levels where you can manage your collations. I'd like to suggest that you append the collation that's required by the current UI to the query.

Are you also going to store dates from regions where they speak those languages? If that's the case, you'd also need to check whether the datatimes in the database are all stored in the same timezone (using server-time!) or the local users' time. The latter should be entered in the database re-adjusted to the timezone of your server, or, alternatively, stored the timezoneinformation in an accompanying field.

That should be enough to get you up and running. Enjoy Smile | :)

I are Troll Suspicious | :suss:

SQL Server Report Services direct to printer and PDF format

Central_IT17-Nov-10 0:31

Central_IT

17-Nov-10 0:31

I am in the process of writing multiple reports for a system developed using Visual Studio 2008 (VB.Net)and running SSRS 2008. Is it possible when you click a "Print" button that rather than the report showing up in the report viewer window first, that the report be sent directly to the printer without viewing it in a window first. Unfortunately, since I am fairly new to Reporting Services, I cannot figure out the process to do this.

So basically, is there a way I can print a report without viewing it first?

Other....
I know the users are going to ask as well as sending the report directly to printer, to save it in a PDF format. Can this be done?

save / read image in mysql

Jassim Rahma17-Nov-10 0:16

Jassim Rahma

17-Nov-10 0:16

I am looking for the steps on how to save and how to read images from/to mysql using C#?

Thanks.

Re: save / read image in mysql

Eddy Vluggen17-Nov-10 0:18

Eddy Vluggen

17-Nov-10 0:18

jrahma wrote:
I am looking for the steps on how to save and how to read images from/to mysql using C#?

Would a CodeProject article[^] on the subject help?

I are Troll Suspicious | :suss:

SQL Server - Transaction Log - auto shrink?

devvvy16-Nov-10 20:35

devvvy

16-Nov-10 20:35

hello - how can you configure auto shrink for SQL server Trasnaction log?

Thanks

dev

Re: SQL Server - Transaction Log - auto shrink?

Goutam Patra16-Nov-10 21:18

Goutam Patra

16-Nov-10 21:18

EXEC SP_DBOPTION 'MYDBNAME', 'trunc. log. on chkpt', true

modified on Wednesday, November 17, 2010 3:29 AM

simple recovery model

David Mujica17-Nov-10 3:14

David Mujica

17-Nov-10 3:14

Before you shrink/truncate your transaction log, make sure you have a proper backup so that you can recover the data. You may want to investigate the Simple Recovery Model for your backups.

Read this article http://databases.about.com/od/sqlserver/a/recoverymodels.htm[^]

SSIS and stored procedures

tim_gunning16-Nov-10 10:15

tim_gunning

16-Nov-10 10:15

hi all

I was wondering if anyone could help, I need to pass 2 variables to a stored procedure that in turn fires off an SSIS job that calls a stored procedure.... (dont ask!). I can get the variables into the stored procedure no problem, but getting them through to the job is proving harder than I would expect. I can set static params through the Set Values option but cannot see a way of making them dynamic ?> any thought greatly appreciated

ta

Re: SSIS and stored procedures

Manfred Rudolf Bihy16-Nov-10 12:01

Manfred Rudolf Bihy

16-Nov-10 12:01

Can you post some code from the stored procedure where you "fire off" the SSIS job?

Greetings

Manfred

Re: SSIS and stored procedures

robertford16-Nov-10 14:25

robertford

16-Nov-10 14:25

ta,

I am sure that there is a way to pass those values though another option that I have used before is to update a parm table with the values from the stored procedure and then kick off the SSIS package which reads the parm table.

I hope that this helps

Robert Ford

correct the expression of the textbox field

vinu.111115-Nov-10 23:36

vinu.1111

15-Nov-10 23:36

hi... to all..

i've written the code in expression field...

=format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00")

the code is for printing the number in this format(12,23,23,34,123.00)

now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas

are printed.. i dont want to print the extra commas.. how the word length is there that much it

should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...

i've tried by removing some of the #'s but it is for fixed number..

please help me...

Re: correct the expression of the textbox field

Geoff Williams16-Nov-10 1:07

Geoff Williams

16-Nov-10 1:07

It is customary to group 3 digits at a time. To achieve that you simply need to use "#,##0.00" as your number format - the result will contain as many ',' characters as necessary e.g.

Format(123.45, "#,##0.00") -> 123.45
Format(1234.56, "#,##0.00") -> 1,234.56
Format(12345.67, "#,##0.00") -> 12,345.67
Format(123456.78, "#,##0.00") -> 123,456.78
Format(1234567.89, "#,##0.00") -> 1,234,567.89

Re: correct the expression of the textbox field

vinu.111116-Nov-10 1:08

vinu.1111

16-Nov-10 1:08

thanku.. for reply
i have just change the language setting..

need help to code in c# to update image

chandru22215-Nov-10 22:23

chandru222

15-Nov-10 22:23

please help to update image using c# i'm new to .net
i have successfully inserted image in database but i couldn't update it,using c# if any one finds the answer please let me know it

advance thanks Laugh | :laugh:

Re: need help to code in c# to update image

Eddy Vluggen16-Nov-10 0:02

Eddy Vluggen

16-Nov-10 0:02

chandru222 wrote:
i have successfully inserted image in database but i couldn't update it

Why not? Did you get an error? What did it say?

I are Troll Suspicious | :suss:

Retrive data from Access table

vijay248215-Nov-10 2:17

vijay2482

15-Nov-10 2:17

Hi all,

Re: Retrive data from Access table

Eddy Vluggen15-Nov-10 4:45

Eddy Vluggen

15-Nov-10 4:45

vijay2482 wrote:
I would like to know how to retrive data from Access table to a excel spread sheet with a click of a button in the excel spreadsheet.

Using VBA. I don't have the exact code - you'll have to search a bit Smile | :)

I are Troll Suspicious | :suss:

Re: Retrive data from Access table

Blue_Boy15-Nov-10 9:51

Blue_Boy

15-Nov-10 9:51

Better start to learn C# or any another programming language.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Re: Retrive data from Access table

jschell16-Nov-10 9:00

jschell

16-Nov-10 9:00

Blue_Boy wrote:
Better start to learn C# or any another programming language.

You can use C# as a macro language in Excel?

Re: Retrive data from Access table

Eddy Vluggen16-Nov-10 9:15

Eddy Vluggen

16-Nov-10 9:15

Like this[^] Poke tongue | ;-P

I are Troll Suspicious | :suss:

Adding mysql data to postgresql

franrtorres7714-Nov-10 1:51

franrtorres77

14-Nov-10 1:51

Hi there

I need to add periodically some data from a remote mysql database into our postgresql database. So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?

Best regards

Re: Adding mysql data to postgresql

Eddy Vluggen16-Nov-10 0:11

Eddy Vluggen

16-Nov-10 0:11

franrtorres77 wrote:
So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?

Perhaps the Sync Framework[^]? I'm not sure on the performance though.

I are Troll Suspicious | :suss:

Re: Adding mysql data to postgresql

RaviRanjanKr17-Dec-10 18:36

RaviRanjanKr

17-Dec-10 18:36

Addy already given you a perfect Link, you can also try the given link
Exporting MySQL and PostgreSQL Database Contents[^]

Hope it will work for you.

MySQL Select help required

djhankypark12-Nov-10 12:11

djhankypark

12-Nov-10 12:11

Could someone pont me in the right direction here cos I am pulling my hair out and I have little to start with lol

I am working with 3 tables

User Table:
Auto_ID
User_Name

Profile Table:
Auto_ID
User_ID (This is taken from the Auto_ID in the User Table e.g. 20)
Prof_Img

Comments Table:
Auto_ID
Message_To (This is taken from the Auto_ID in the User Table e.g. 41)
Message_From (This is taken from the Auto_ID in the User Table e.g. 20)
Message

I need to be able to display the Prof_Img for who the message was _to and _from I just can't figure how to get the individual picture references from the same table in the same query. I can get one of the pictures but not both, am probably not thinking about it correctly, well obviously I am or it would work lol

Oh and I need the User_Name to go with each relevant picture

If someone could give me a little guidance please it would save my hair line lol

Many thanks in advance

Regards

Ray

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.